-
sudo port install postgresql93-server
-
sudo port select --set postgresql postgresql93
-
sudo port load postgresql93-server
-
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'
-
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';
-
postgres_start
-
createuser -P -s -e you -U postgres
-
sudo port install postgis2 +postgresql93
Last active
August 29, 2015 14:05
-
-
Save jczaplew/73682d7eebfebc037406 to your computer and use it in GitHub Desktop.
Set up Postgresql93 with Macports
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment