psql: could not connect to server: Bad file descriptor - Mailing list pgsql-cygwin

From Eliza Ochoa
Subject psql: could not connect to server: Bad file descriptor
Date
Msg-id 20030626020308.73419.qmail@web14705.mail.yahoo.com
Whole thread Raw
Responses Re: psql: could not connect to server: Bad file descriptor
List pgsql-cygwin
Hi,
 
I installed postgresql 7.3.2 with cygwin, following exactly what was in the readme.   The only deviation I made was I added the user postgres and set its right to log on as service before even installing cygwin.  This does not matter, does it?
 
The installation went fine, but my postgres could not be run by any other user except user "postgres".  I get the following error:
 
# psql template1
psql: could not connect to server: Bad file descriptor
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
 
I checked the file permissions for /tmp/.s.PGSQL.5432 and they seem to be correct:
srwx------    1 postgres None            /tmp/.s.PGSQL.5432
 
I later tried to change the file permissions and managed to change it though CYGWIN's faq said chmod doesn't work.  So I had:
srwxrwxrwt    1 postgres None            /tmp/.s.PGSQL.5432
 
And I still get the same error.  Worse, now my postgres user couldn't run psql either.  And when I wanted to change the file permissions back, chmod won't work anymore.
 
Could anyone tell me how to solve this problem?
 
Thanks,
Tiffany
 


Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: Postmaster doesn't start under CygWin (semctl failed)
Next
From: Jason Tishler
Date:
Subject: Re: psql: could not connect to server: Bad file descriptor