9 May 2010

PostgreSQL 8.3 on OSX with MacPorts

Installing PostgreSQL on OSX Snow Leopard is pretty sinple, just install MacPorts and the issue the command:

$ sudo port install postgresql83 +universal


Start the server with:
$ sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql83-server.plist


Stop the Server with:
sudo launchctl unload -w /Library/LaunchDaemons/org.macports.postgresql83-server.plist

Use PgAdmin III for getting started and administering your databases.