Skip to content

Instantly share code, notes, and snippets.

@jczaplew

jczaplew/setup.md

Last active August 29, 2015 14:05
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 jczaplew/73682d7eebfebc037406 to your computer and use it in GitHub Desktop.
Save jczaplew/73682d7eebfebc037406 to your computer and use it in GitHub Desktop.
Download ZIP
Set up Postgresql93 with Macports
Raw
setup.md

Set up Postgresql93 with Macports

  1. sudo port install postgresql93-server

  2. sudo port select --set postgresql postgresql93

  3. sudo port load postgresql93-server

  4. sudo mkdir -p /opt/local/var/db/postgresql93/defaultdb

  5. sudo chown postgres:postgres /opt/local/var/db/postgresql93/defaultdb

  6. sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb'

  7. Add to ~/.bash_profile...

    Append to $PATH: /opt/local/lib/postgresql93/bin

    alias postgres_start='sudo /opt/local/etc/LaunchDaemons/org.macports.postgresql93-server/postgresql93-server.wrapper start';

    alias postgres_stop='sudo /opt/local/etc/LaunchDaemons/org.macports.postgresql93-server/postgresql93-server.wrapper stop';

    alias postgres_restart='sudo /opt/local/etc/LaunchDaemons/org.macports.postgresql93-server/postgresql93-server.wrapper restart';

  8. postgres_start

  9. createuser -P -s -e you -U postgres

  10. sudo port install postgis2 +postgresql93

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