I am not sure what the source of my original problem was with 9.0.3 because I was getting this problem:
psql: FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory
However as stated above it turns out that the running process was for my previous postgres install of 9.0.3
I believe I had an old version org.postgresql.postgres.plist in ~/Library/LaunchAgents/
I had to:
- Remove and re-add the launch agent
- Kill the processes for 9.0.3
- Initialize the db
initdb /usr/local/var/postgres
- Restart my computer
and now I have it up and working.