Getting PostgreSQL server to run on Lion

Nathan Sims <[email protected]> Tue, 20 Mar 2012 09:36:13 -0700

Newsgroups	gmane.comp.macosx.admin
Message-ID	<[email protected]>

I just upgraded a OSX 10.6.8 system to Lion 10.7.3. Supposedly Lion comes with PostgreSQL 9.1.1 preinstalled. How do you enable/activate/launch it? There are no postgres processes running on the system.

$ psql -d postgres -U postgres
psql: could not connect to server: Permission denied
        Is the server running locally and accepting
        connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?