Postgres start/stop commands

01_terminal

# Start Postgres
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

# Stop Postgres
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log stop

02_bash_profile

# Alias them how you like, here's an example that I use.
# Copy and paste this into your .bashrc or .bash_profile (whichever you use).

alias pgsqlstart="pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start"
alias pgsqlstop="pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log stop"


#---------------------------------------
# Now to start Postgres, just type
$ pgsqlstart

# To Stop Postgres,
$ pgsqlstop