Furthermore, psql did work under administrator when I did a chmod 777 ...
$ ls -l .s*
-rwx------ 1 postgres None 51 Jun 15 18:21 .s.PGSQL.5432
-rw------- 1 postgres None 31 Jun 15 18:21 .s.PGSQL.5432.lock
Administrator@xxx /tmp
$ ls -l .s*
srwxrwxrwt 1 postgres None 0 Jun 15 18:21 .s.PGSQL.5432
-rwxrwxrwx 1 postgres None 31 Jun 15 18:21 .s.PGSQL.5432.lock ----- Original Message -----
Sent: Sunday, June 15, 2003 6:25 PM
Subject: Problems with permissions after CYGWIN upgrade
I refer to a recent post ...
I have the same problem even though I am using the "postmaster -i" workaround you proposed.
This is a new installation:
Cygwin 1.3.22-1
cygipc 1.14
postgres 7.3.3
I believe I followed the install instructions in the README ... in particular# cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown
... this appears to specify the "-i" option.
The error I receive is as follows:
Administrator@xxx ~
$ psql -U postgres 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"?
both the IPC-daemon and postmaster services are running
FYI
$ ls -l /tmp/.s*
-rwx------ 1 postgres None 51 Jun 15 18:21 /tmp/.s.PGSQL.5432
-rw------- 1 postgres None 31 Jun 15 18:21 /tmp/.s.PGSQL.5432.lock
BUT when logged in as user postgres ... psql works
All suggestions greatly appreciated
