Hi,
I've been fiddling with cygipc and postgres for two nights now,
reading manuals and mailing list archives, but I can't get it quite
right.
psql template1 works just fine if I'm logged in as user "postgres"
which is the account the service runs with. I ran the createuser
script as user "postgres" to create another user "markus". There were
no error messages. From my user account "markus", I get the following
error:
markus@WUTZ ~
$ ls -l /tmp/.s.PGSQL.5432
srwxrwxrwx 1 postgres Kein 51 Jul 30 22:46 /tmp/.s.PGSQL.5432
markus@WUTZ ~
$ psql template1
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
markus@WUTZ ~
$ psql -U postgres template1
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
I think I can answer both questions with "yes", so I'm kinda stuck
what to try next. The same problem occurs from any other user account
except postgres, incl the administrator account.
System information
WinNT4 SP3
Cygwin DLL 1.3.2, complete installation updated approx 2 weeks ago
cygipc (1.09) and postgres run as user postgres. This account has the
special rights as mentioned in the cygipc readme, i.e. start as daemon
etc.
postgres was installed with:
cygrunsrv -I postgres -p "/usr/bin/pg_ctl" -a "start -D
/var/lib/psql/data -o '-i' -l /var/log/psql.log" -u postgres -w
postgres
net start postgres results in an error message (service not started
blah blah) but the logs indicate that the daemon started ok and the NT
task manager shows postgres.exe running.
The configuration files in /var/lib/psql/data are untouched, i.e. the
access control is set to "wide open" for everyone.
Any help is greatly appreciated
Markus
--
Markus Hoenicka
hoenicka_markus@compuserve.com
http://ourworld.compuserve.com/homepages/hoenicka_markus/
