How to install PostgreSQL on OS X Lion

On July 31, 2011, in LION, by admin

1 Just a quick note to report that both my PostgreSQL 8.3.7 installs survived the upgrade to OS X Lion. PostgreSQL was installed via Mac Ports
2 Lion update removed the ‘postgres’ user. How to restore it
In the end, the only thing I needed to do was to re-create the “postgres” user. Beforehand, I listed the contents of /usr/local/pgsql/ and saw that for instance the data/ directory was owned by user 101 and group postgres. So I wanted to tie that postgres user to the 101 userid:

sudo dscl . -create /Users/postgres
sudo dscl . -create /Users/postgres UniqueID 101

(And afterwards I restarted my mac as I didn’t know how to start that postgres server by hand… ;-)


Tagged with: