NFSHomeDirectory: /opt/local/var/db/postgresql90 View the postgres user account just to make sure it all looks OK: create /Users/postgres UserShell /bin/bash I prefer to change the postgres user's shell to bash: $ sudo -u postgres /opt/local/lib/postgresql90/bin/initdb -D /opt/local/var/db/postgresql90/defaultdb Now you need to initialize the database using the data directory that was created above: $ sudo chown -R postgres:postgres /opt/local/var/log/postgresql90 $ sudo mkdir -p /opt/local/var/log/postgresql90 $ sudo chown -R postgres:postgres /opt/local/var/db/postgresql90 $ sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb
Use the MacPorts command port to install PostgreSQL 9.0, then create and own a data directory and a logs directory: I'm hopeful that this will help others as well.
So I'm documenting this process for my own sake because I have been through this now twice on two computers recently, having to hunt down all of these commands each time. While installing PostgreSQL 9.0 on Mac OS X again, I had to figure out all these steps yet again.
