Skip to content

Instantly share code, notes, and snippets.

@jeffmcfadden
Created April 17, 2012 20:27
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 jeffmcfadden/2408778 to your computer and use it in GitHub Desktop.
Save jeffmcfadden/2408778 to your computer and use it in GitHub Desktop.
StartStop Postgres Locally
# I installed via homebrew
# Start
$ pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
# Stop
$ pg_ctl -D /usr/local/var/postgres stop -s -m fast
# Make the DB:
$ psql postgres
# CREATE USER samsoffes SUPERUSER;
# CREATE DATABASE samsoffes_development OWNER samsoffes;
# CREATE DATABASE samsoffes_test OWNER samsoffes;
# \q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment