Skip site navigation (1) Skip section navigation (2)

psql: could not connect to server: Bad file descriptor

From: Eliza Ochoa <ce_8965(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: psql: could not connect to server: Bad file descriptor
Date: 2003-06-26 02:03:08
Message-ID: 20030626020308.73419.qmail@web14705.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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!

Responses

pgsql-cygwin by date

Next:From: denisDate: 2003-06-26 05:37:07
Subject: Re: psql: could not connect to server: Bad file descriptor
Previous:From: Jason TishlerDate: 2003-06-25 20:07:51
Subject: Re: Postmaster doesn't start under CygWin (semctl failed)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group