Re: 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: Re: Error message "psql: could not connect to server: No such file or directory"
Date: 2012-06-19 08:32:57
Message-ID: 01F83EDC-49B3-498A-8FFD-681EFDB6B8AC@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I need unfortunately to come back to this issue. I (again) re-installed Lion from scratch, and finally got everything working. The Postgres was running, I uploaded a couple of dumped SQL files. And then re-started the machine for another reason. And suddenly it says again the it can't connect to the server.

I tried
/usr/local/pgsql-9.1/bin/initdb -U postgres -D /usr/local/pgsql-9.1/data --encoding=UTF8 --locale=en_US

and
/usr/local/pgsql-9.1/bin/pg_ctl -D /usr/local/pgsql-9.1/data/ -l logfile start

and
sudo launchctl load /Library/LaunchDaemons/org.postgresql.postgres.plist

… but nothing happens. I don't have the feeling that it's a problem with the "postgres" and "_postgres" users (as it has worked before already).

Can anyone give me a hint how I can figure out where the problem lies and what I can do about it? Why did it work before I restarted the computer and why does it not work anymore?

Thanks a lot for any hints!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2012-06-19 09:00:49 Re: Fine-grained replication?
Previous Message pandorino 2012-06-19 07:58:29 pgstat wait timeout : permission denied