Here’s the quick answer to making the Enterprisedb one click installer for PostgreSQL 8.4 on Lion to work.
1st – Go into the system settings, and create a regular user called: postgres and set a password. That is the biggest key – Lion doesn’t like the 1 click installer messing with system users & security, and they have a different, hidden user for their version.
2nd – run the installer, and be sure to set the port postgres runs to something that’s not 5432. I usually just use 5433 when I have the case of multiple instances.
For local access all will be good. For remote / multi-user access, you have to edit your pg_hba.conf files – but be careful – file ownership issues will flag a “non-zero status” error if you forget to set the data directory back.
I did have to set data permissions for the data directory to fix a “world read write” message on start up.
Just :
su postgres – and navigate to the /Library/PostrgeSQL/8.4 directory, and type:
chmod 700 data
Restart your postgres server.