client connection problem

From: "Markus Hoenicka" <hoenicka_markus(at)compuserve(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: client connection problem
Date: 2001-07-31 00:04:44
Message-ID: 15205.63004.459000.191613@gargle.gargle.HOWL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)WUTZ ~
$ ls -l /tmp/.s.PGSQL.5432
srwxrwxrwx 1 postgres Kein 51 Jul 30 22:46 /tmp/.s.PGSQL.5432

markus(at)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(at)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(at)compuserve(dot)com
http://ourworld.compuserve.com/homepages/hoenicka_markus/

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2001-07-31 08:15:13 RE: postgresql on win2000
Previous Message Jason Tishler 2001-07-30 19:44:32 Re: Version number in file '/cygdrive/d/pgsql/data/PG_VERSION' should be 7.0, not 7.0