Thread: client connection problem

client connection problem

From
"Markus Hoenicka"
Date:
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/


installing pgsql using cygwin (win nt/2000)

From
Swaroop Kavalanekar
Date:
Hi,
    I tried installing cypipc-1.09-2. I did
    ipc-daemon --install-as-service
After that when I tried to do
    net start ipc-daemon
I got the message
The service is not responding to  the control function

A window popped up saying The dynamic link library cygwin1.dll could not
be found in the specified path.

Any suggestions.
Swaroop