Re: Error message "psql: could not connect to server: No such file or directory"

On 06/14/2012 06:30 AM, Stefan Schwarzer wrote:
> Hi there,
>
> I guess this is a typical user error. I searched around to find the solution, but in vain.
>
> I just upgraded to Lion, and used Kyngchaos libraries for installation of Postgres.
>
> Try to get running postgres, and I get this:
>
>        /usr/local/pgsql-9.1/bin/psql -U postgres
>        psql: could not connect to server: No such file or directory
>           Is the server running locally and accepting
>           connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
>
> In my limited understanding, it seems that Postgres is not running. When I use:
>
>         ps auxw | grep post
>
> out comes only the "grep post", but no postgres process.
>
> When I use:
>
>         sudo launchctl load /Library/LaunchDaemons/org.postgresql.postgres.plist
>
> it says:
>
>         org.postgresql.postgres: Already loaded
>
> and displays in the "ps" list then:
>
>         user        935   0.0  0.1  2493888   7296   ??  Ss    3:24PM   0:00.12
/System/Library/PrivateFrameworks/DiskImages.framework/Resources/diskimages-helper-uuid
9EFB9424-7971-4A8B-9D73-B93BD7F1DB5F-post-exec 4 
>
> (which looks a bit strange to me (DiskImages ??))
>
>
> I am somewhat lost (and worse is that it worked the other day, before re-installing Lion anew.).

http://www.kyngchaos.com/software/postgres
"
Notes

NOTE: I've had reports of the installer not initializing the data
cluster, which results in Postgres not starting. It seems to be random,
and I haven't figured out the cause yet. If Postgres won't start (you
get an error "could not connect to server: No such file or directory"
when trying to connect with psql), try manually initializing the cluster
with:
/usr/local/pgsql-9.1/bin/initdb -U postgres \
-D /usr/local/pgsql-9.1/data --encoding=UTF8 --locale=en_US"
Or see the Locales and Encodings readme if you need a different locale
or encoding.
Then stop and start Postgres as specified in the readme.
"
>
> Thanks for any hints,
>
> Stef


--
Adrian Klaver
adrian.klaver@gmail.com