client connection problem
От | Markus Hoenicka |
---|---|
Тема | client connection problem |
Дата | |
Msg-id | 15205.63004.459000.191613@gargle.gargle.HOWL обсуждение исходный текст |
Ответы |
installing pgsql using cygwin (win nt/2000)
|
Список | pgsql-cygwin |
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/
В списке pgsql-cygwin по дате отправления: