Re: connectDBStart() -- connect failed - Mailing list pgsql-novice

From Art Nicewick
Subject Re: connectDBStart() -- connect failed
Date
Msg-id OFAD3AB3F7.4E9189BE-ON85256B6C.006D3051@ams.com
Whole thread Raw
List pgsql-novice
connection refused Is the postmaster running locally and accepting
connections on UNIX sockets '/tmp/.s.PGSQL.5432'?

I'm running on CYGWIN/wintel.


pg_ctl stop  gives

       waiting for postmaster to shutdown
........................................................................................................

failed
      pg-ctl: postmaster doe not shutdown

pg-ctl start gives

          Another postmater may be running. Trying to start postmaster
anyway.
          postmaster successfully started


It was working fine ... However my loads were very slow,  I turned on fsync
(fsync=off). and it would not restart. I turned it back on again, and it
still dos'nt start.




There is not Postmaster task.  (ps -ef )
I deleted the Postmaster.pid
A /tmp/.s.PGSQL.5432             file does exist .
A /tmp/.s.PGSQL.5432.lock    file does exist .
---------------------------------------------------------------------------------------------------------

Arthur Nicewick
American Management Systems
Corporate Technology Group
art_nicewick@ams.com
(703) 267-8569

Quote of the week:
"Computers in the future may weigh no more than 1.5 tons."
Popular Mechanics, forecasting the relentless march of science, 1949


pgsql-novice by date:

Previous
From: Jason Earl
Date:
Subject: Re: update
Next
From: Phil Mitchell
Date:
Subject: Re: Help formulating multi-table SELECT statement