kamal-github/postgres_start_and_login.md

Last active May 4, 2016 11:48

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kamal-github/fcf0662b6a96136d704df990c26efb74.js"></script>
Save kamal-github/fcf0662b6a96136d704df990c26efb74 to your computer and use it in GitHub Desktop.

Raw

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

Also, To login for the first time -

sudo -u kamal psql postgres

where kamal is superadmin and postgres is default DB name

Select an option