Start and Stop PostgreSQL manually on Mac OS X

( from http://stackoverflow.com/questions/7975556/how-to-start-postgresql-server-on-mac-os-x )

The Homebrew package manager includes launchctl plists to start automatically. For more information run brew info postgres.

Start manually:

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

Stop manually:

pg_ctl -D /usr/local/var/postgres stop -s -m fast