Re: Psql refusing to start as Win2000 Service

Pavel,

Oh this brings back memories. Look through the archives at
archives.postgresql.org for the many threads I and Jason of this parish had
over issues very similar to this. In summary here are a few tips :

totally remove Cygwin, cyipc and its service entry
Check your firewall (I use zonealarm) - delete ANY reference in its memory
about Internet permissions for postmaster and postgres programs.

Download the 1.3.10 cygwin build (no earlier), install everything in the
right order (Jason has published decent details on this in the readme that
comes with the postgresql 7.2-2 package for cygwin, readable after you
install it with cygwin's installer).

Your description of the processes you are taking seem very accurate having
been through this frustrating cycle myself many times. You'll bne pleased
to hear I have 7.2-2 running find now as service under user ./postgres on W2k.

So, IT IS POSSIBLE! Keep going.  Sorry not to be able to pinpoint precisely
why its going wrong.

Tim.

At 10:21 16/03/2002 +0100, Pavel Hofman, inSITE, s.r.o. wrote:
>Hi,
>
>I have been struggling for days to start the latest  cygwin postgresql
>7.2 as a service on Win2000 Professional. It runs standalone, but does
>not want to start in the service mode.
>
>This is what I did (following the docs and some good tips provided in
>this newsgroup):
>
>1. created the "postgres" user with "Log on as service" permissions.
>
>2. started the CYGIPC as a service, run inder the postgres user - OK.
>
>3. initdb - OK, no failure (when CYGIPC ran under the SYSTEM user,
>initdb complained, but this way it runs smoothly)
>
>4. Started postmaster from shell - runs OK, I can connect with psql
>etc. - no problem. Runs OK when started from cygwin bash as well as
>from Win command window.
>
>5. Installed the service as an Administrator:
>
>cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-d 6
>-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig TERM
>--user postgres
>
>The password I entered was OK, I even tried
>cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-d 6
>-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig TERM
>--user postgres -W "postgres"
>
>where postgres is the password. I tried a wrong password and Win
>complained - I assume that's not the problem.
>
>When I want to start the service (net start postmaster or using GUI),
>it says something like "Service could not start, but the application
>did not return any error". I could not find any log (created by
>postmaster or cygrunsrv), or relevant record in NT logs.
>
>I tried to run the service as SYSTEM - it would not start sucessfully,
>but at least put info into /var/log/postmaster.log about wrong
>permissions in /usr/share/postgresql/data - that's corrent and I
>assume postgresql would run OK from service under SYSTEM.
>
>I even tried running a small bash script instead of the
>/usr/bin/postmaster,
>  echoing some string into a file in /tmp - it would create the file
>when started as service under SYSTEM, but would not do anything when
>started as service under postgres.
>
>I suspect a problem with path, but the system Path variable lists the
>c:\cygwin\bin;c:\cygwin\usr\bin paths. Then I guess CYGIPC would be
>having problems - but it runs OK as a service under postgres.
>
>Furthermore, I wonder if the cygrunsrv is really intended not to put
>any logs of its activity - that would help greatly.
>
>I would really appreciate any hints. Thank you.
>
>Pavel Hofman.
>
>
>
>---------------------
>
>inSITE, s.r.o.
>
>Rubesova 29, 301 53 Plzen
>Tel., fax: +420 - 19 - 74 493 58
>GSM: +420 - 603 - 163 973
>Email: pavel.hofman@insite.cz
>www.insite.cz
>
>
>---------------------------(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

Tim Finch,
FosterFinch Ltd
http://www.fosterfinch.co.uk