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:  
Comments

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...

Support us!

If you like this site please help and make click on any of these buttons!

×