PostgreSQL on Mac using macports

Start:
sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql84-server.plist

Stop:
sudo launchctl unload -w /Library/LaunchDaemons/org.macports.postgresql84-server.plist

Locations

/opt/local/var/db/postgresql92/defaultdb
/opt/local/lib/postgresql92/
/opt/local/share/postgresql92/

Configuration

Change /etc/sysctl.conf to the following in order to increase access to shared memory...

kern.sysv.shmmax=1610612736
kern.sysv.shmmin=1
kern.sysv.shmmni=256
kern.sysv.shmseg=64
kern.sysv.shmall=393216

Stuff

gunzip -c database_data.dump.gz | /opt/local/lib/postgresql92/bin/psql -d database_name

About Humanise

We focus on user experience and design. We seek out the most simple and essential solution. We believe that machines should work for people. We think that knowledge should be free and accessible to all. We hope you agree :-)

More about Humanise »

Contact

Jonas Brinkmann Munk

jonasmunk@mac.com · +45 28 77 63 65

Kenni Graversen

gr@versen.dk · +45 22 48 61 53

hand