Thread: Install postmaster as service in win2K
Hello, Has anybody tried starting postmaster as a service in Win2k? What are the steps for it? Also, how does one assure that ipc-deamon as service starts ahead of postmaster in that case? Thanks for any pointers. Regards. -Samik
Hello, I didn't get any reply to the following post, but I progressed a bit in the direction. I put a service with 'Path to executable' as 'E:\Unixroot\bin\bash.exe pg_ctl start -D /usr/local/pgsql/data -o "-i"' and put a dependency on ipc-daemon, which I have already installed as service. ipc-daemon starts fine, but this service still doesn't start. Interesting part is, if I issue the same line from command prompt, postmaster starts successfully. Any comments or suggestions? Thanks and regards. -Samik samik@cae.wisc.edu (Samik Raychaudhuri) wrote in message news:<fbf5e750.0202061606.74e5b3e7@posting.google.com>... > Hello, > Has anybody tried starting postmaster as a service in Win2k? What are > the steps for it? Also, how does one assure that ipc-deamon as service > starts ahead of postmaster in that case? > Thanks for any pointers. > Regards. > -Samik
Just a followup to my previous mail: I am getting this error, when I am trying to manually start the service from the Control- Panel -> Services Tab: Could not start PGSQL Database service on local computer. Error 1053: The service didn't respond to the start or control request in a timely fashion. Thanks -Samik
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
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
>
"Carlo Florendo" <fcarlo@ntsp.nec.co.jp> writes:
> 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'?
Try
psql -d test -h localhost
Not sure why libpq isn't set up to do that by default on platforms where
there is no Unix-socket support. Anyone want to submit a patch?
regards, tom lane