Skip to content

Instantly share code, notes, and snippets.

@kamal-github

kamal-github/postgres_start_and_login.md

Last active May 4, 2016 11:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kamal-github/fcf0662b6a96136d704df990c26efb74 to your computer and use it in GitHub Desktop.
Save kamal-github/fcf0662b6a96136d704df990c26efb74 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres_start_and_login.md

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment