sudo port install postgresql84 postgresql84-server
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'

sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql83-server.plist

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

sudo su postgres -c 'pg_ctl -D /opt/local/var/db/postgresql84/defaultdb/ restart'

sudo su postgres -c '/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data restart'

postgres@mail> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

launchctl unload ~/Library/LaunchAgents/org.postgresql.postgres.plist
launchctl load ~/Library/LaunchAgents/org.postgresql.postgres.plist

sudo SystemStarter start PostgreSQL

sudo port load postgresql92-server

sudo port unload postgresql92-server

ls /Library/LaunchDaemons/*postgresql*

pgctl_func() {

    if [ -z $1 ]; then
       echo "usage: pgctl start|stop|restart"
       return 0
    fi

    pgctl_cmd=$(mktemp -t "$0")
    echo 'source $HOME/pg_env.sh; ' > pgctl_cmd
    echo "pg_ctl -m fast $1" >> pgctl_cmd

    sudo su -l postgres < pgctl_cmd
}
alias pgctl='pgctl_func'