Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: postgres help[Scanned]

Re: postgres help[Scanned]

From
"Jason Tishler"
Date:

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/

Re: psql could not connect to server

From
Seth Rubin
Date:
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@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Jason Tishler
Sent: Sunday, September 14, 2003 10:37 PM
To: Jason House
Cc: cygwin@cygwin.com; pgsql-cygwin@postgresql.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/