Install postmaster as service in win2K - Mailing list pgsql-general

Hi,

I was trying to install postgres as a service in win2k  It was both successful and unsuccessful.

Successful in the sense that I could connect to the server (coolio.ntsp.nec.co.jp) from another machine
by running

"psql -d test -h coolio.ntsp.nec.co.jp"

Unsuccessful in the sense that when I connect locally by

"psql -d test"

I get this error message:

connectDBstart() -- connect() failed: No such file or directory
 Is the postmaster running locally
 and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?


I checked the bottom part of the manual file postmaster-start.html and it said this:

---------start quote---------------
Alternatively, you'll get this when attempting Unix-socket communication to a local postmaster:

connectDBstart() -- connect() failed: No such file or directory
    Is the postmaster running locally
    and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

The last line is useful in verifying that the client is trying to connect where it is supposed to. If there is in fact
nopostmaster 
running there, the kernel error message will typically be either Connection refused or No such file or directory, as
illustrated.
(It is particularly important to realize that Connection refused in this context does not mean that the postmaster got
your
connection request and rejected it -- that case will produce a different message, as shown in Section 4.3.) Other error
messages
such as Connection timed out may indicate more fundamental problems, like lack of network connectivity.

-----------end of quote---------------


How am I supposed to connect using TCP sockets and not UNIX sockets.  And why did it try to connect using UNIX sockets?


Many Thanks!

Carlo Florendo
NEC Telecoms
fcarlo@ntsp.nec.co.jp

----- Original Message -----
From: "Samik Raychaudhuri" <samik@cae.wisc.edu>
To: <pgsql-general@postgresql.org.pgsql-cygwin@postgresql.org>
Sent: Monday, February 11, 2002 2:53 PM
Subject: Re: [GENERAL] Install postmaster as service in win2K


> Seems I am the only person posting to this thread ;)
> It's time to wrap up...
> I got the things done, by following the instructions line by line as
> given in postgresql-7.1.3 readme.
> A copy of the file is available here:
> http://www.ejip.net/faq/postgresql-7.1.3.README
> And an error correction is here:
> http://archives.postgresql.org/pgsql-cygwin/2001-08/msg00107.php
> Thanks and enjoy installing.
> -Samik
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>