PostgreSQL on Lion

2011-08-27 Me

The installer for Postgresql on Lion is supposedly “unsupported”, which means that they haven’t got it working yet. Looking at it quickly is seems to be the way that the postgres user is being created using dscl.

To get it to work, manually create a postgres user from under System Preferences:

Then run the installer as per normal. I used the Postgres 9 installer.

I also upgraded python to 2.7.2 and installed psycopg2 pointing to pg_config under /Library/PostgreSQL/9.0/bin/pg_config.