Skip to content

Instantly share code, notes, and snippets.

@chriskief
Last active December 28, 2015 13:39
Show Gist options
  • Save chriskief/7509503 to your computer and use it in GitHub Desktop.
Save chriskief/7509503 to your computer and use it in GitHub Desktop.
# install and select
sudo port install postgresql93-server
sudo port select --set postgresql postgresql93
# load at startup
sudo port load postgresql93-server
# create the default database
sudo mkdir -p /opt/local/var/db/postgresql93/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql93/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb'
# create a new user (or you can simply use the default user postgres which does not require a password)
createuser --superuser your_username -U postgres -P
# create a new database
createdb database_name
@ChicagoDev
Copy link

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