plugins/postgres/README.md
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)
| 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) |