I had something similar happen to me today. I on WinXPhome and tried to run psql after a fresh bootup (my boot automatically starts init, ipc-daemon2, postmaster), and I got:
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"?
I did ls -l /tmp, but didn't see the file in question. All services were showing as "running". There was nothing unusual in any log files.
My first instinct, which proved to be the solution, was to re-start postmaster (net stop postmaster, net start postmaster). The problem was easily remedied, but I don't want it to ever happen to my users in a production environment, if I can help it.
Cygwin Package Information
Package Version Status
cygipc 2.01-2 OK
cygwin 1.5.4-1 OK
postgresql 7.3.4-2 OK
-- Seth Rubin
Jason,
On Fri, Aug 22, 2003 at 07:12:33PM -0400, Jason House wrote:
> I don't understand why I'm getting the following error:
>
> $ psql -U postgres template1
> 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"?
Was does the following yield?
$ ls -l /tmp/.s.PGSQL.5432
srwxrwxrwx 1 postgres None 0 Aug 23 12:51 /tmp/.s.PGSQL.5432
What version of Cygwin are you using?
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Problem reports: http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/