diff options
| author | navewindre <boneyaard@gmail.com> | 2025-07-13 06:42:05 +0200 |
|---|---|---|
| committer | navewindre <boneyaard@gmail.com> | 2025-07-13 06:42:05 +0200 |
| commit | 02f14a9cb152561a5e44062aac79f3b700403b40 (patch) | |
| tree | 2db8ebda3b7f6f8777783aeb5c60018e6e1359d8 /home/.oh-my-zsh/plugins/postgres | |
| parent | cbbdeb2f6b40a102a829f0c47cff052937231f00 (diff) | |
omz
Diffstat (limited to 'home/.oh-my-zsh/plugins/postgres')
| -rw-r--r-- | home/.oh-my-zsh/plugins/postgres/README.md | 22 | ||||
| -rw-r--r-- | home/.oh-my-zsh/plugins/postgres/postgres.plugin.zsh | 13 |
2 files changed, 35 insertions, 0 deletions
diff --git a/home/.oh-my-zsh/plugins/postgres/README.md b/home/.oh-my-zsh/plugins/postgres/README.md new file mode 100644 index 0000000..3f59a8f --- /dev/null +++ b/home/.oh-my-zsh/plugins/postgres/README.md @@ -0,0 +1,22 @@ +# 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: + +```zsh +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) | diff --git a/home/.oh-my-zsh/plugins/postgres/postgres.plugin.zsh b/home/.oh-my-zsh/plugins/postgres/postgres.plugin.zsh new file mode 100644 index 0000000..b6d365d --- /dev/null +++ b/home/.oh-my-zsh/plugins/postgres/postgres.plugin.zsh @@ -0,0 +1,13 @@ +# Aliases to control Postgres +# Paths noted below are for Postgres installed via Homebrew on OSX +if (( ! $+commands[brew] )); then + return +fi + +local PG_BREW_DIR=$(brew --prefix)/var/postgres + +alias startpost="pg_ctl -D $PG_BREW_DIR -l $PG_BREW_DIR/server.log start" +alias stoppost="pg_ctl -D $PG_BREW_DIR stop -s -m fast" +alias restartpost="stoppost && sleep 1 && startpost" +alias reloadpost="pg_ctl reload -D $PG_BREW_DIR -s" +alias statuspost="pg_ctl status -D $PG_BREW_DIR -s" |