README.md 1.4 KB

Postgres plugin

This plugin adds some aliases for useful Postgres commands.

:warning: this plugin works exclusively with Postgres installed via Homebrew on OSX because Postgres paths are hardcoded to /usr/local/var/postgres.

To use it, add postgres to the plugins array in your zshrc file:

plugins=(... postgres)

Aliases

Alias Command Description
startpost pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start Start postgres server
stoppost pg_ctl -D /usr/local/var/postgres stop -s -m fast Stop postgres server
restartpost stoppost && sleep 1 && startpost Restart (calls stop, then start)
reloadpost pg_ctl reload -D /usr/local/var/postgres -s Reload postgres configuration (some setting require restart)
statuspost pg_ctl status -D /usr/local/var/postgres -s Check status of postgres server (running, stopped)