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

From: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Error message "psql: could not connect to server: No such file or directory"
Date: 2012-06-14 13:30:28
Message-ID: 356A36A0-945E-4D0A-A2C8-3930F29BEDDC@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.).

Thanks for any hints,

Stef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-06-14 13:32:26 Re: Problem installing extensions on Lion
Previous Message Andreas Kretschmer 2012-06-14 13:01:29 Re: about seperate users in PostgreSQL