psql: could not connect to server: Bad file descriptor

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!