Re: psql could not connect to server

Re: postgres help[Scanned]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
-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of Jason Tishler
Sent: Sunday, September 14, 2003 10:37 PM
To: Jason House
Cc: cygwin(at)cygwin(dot)com; pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] postgres help[Scanned]

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/