Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group