Installing postgres with ports on Snow Leopard

gistfile1.sh

sudo port install postgresql84 postgresql84-server

# add this to your path
:/opt/local/lib/postgresql84/bin

# some setup steps
sudo mkdir -p /opt/local/var/db/postgresql84/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql84/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql84/bin/initdb -D /opt/local/var/db/postgresql84/defaultdb'

# create a user and a database
createuser --superuser <username> -U postgres
createdb <dbname>

# start up postgres
sudo su postgres -c '/opt/local/lib/postgresql84/bin/postgres -D /opt/local/var/db/postgresql84/defaultdb'