Re: postmaster service now fails to start under win2k

if I remember well, pgsql creates a postmaster.pid file that you may need to
remove before you can restart pgsql.

HTH

JM

----- Original Message -----
From: "Brian Babey" <bbabey(at)openroadsconsulting(dot)com>
To: "pgsql-cygwin" <pgsql-cygwin(at)postgresql(dot)org>
Sent: Friday, August 09, 2002 8:02 PM
Subject: [CYGWIN] postmaster service now fails to start under win2k

> Hello!
>
> Background: Cygwin 1.3.10(0.51/3/2), PostgreSQL 7.2.1
>
> I had been running ipc-daemon and postmaster as NT services for about a
> month with no problems. I followed the install instructions provided in
the
> READMEs with Cygwin, installing postmaster to run as an NT service as the
> user 'postgres', and running initdb as Administrator since I can't seem to
> switch context to postgres.
>
> As I said this has worked fine for me up until a couple days ago after I
> installed Service Pack 3. When the machine came up from rebooting,
> postmaster did not start, and in the Application Event Log I had this
error:
>
> starting service `postmaster' failed: execv: 1, Not owner.
>
>
> I was unable to manually start the service or use 'net start postmaster',
it
> just quit with the same message. I looked on the archives here and saw a
> recommendation to change the password of the postgres user and reinstall
the
> service, but I had the same result. The only way I could get it working
was
> to reinstall the service to run as 'Administrator' and give him privileges
> to logon as a service. I'd rather not attach this to the Administrator
> account though.
>
> Does anyone know what I could be doing wrong? I tend to think either the
> reboot after SP3 didn't shut down the service gracefully or maybe there
was
> security update in the service pack that finally enforced the discrepancy
in
> ownership between the /usr/share/postgresql/data directory (Administrator)
> and the service (postgres). Regardless, I would appreciate any help or
> advice on this problem!
>
>
> Thanks in advance,
>
>
> Brian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>