Jean-Marc,
Thanks for the suggestion, but the .pid file doesn't appear to be the
problem. While the service is running (as Administrator), postmaster.pid is
there, and when I stop the service, it goes away. I can then start the
service back up again as Administrator and it runs fine, but when I try to
install it to run as 'postgres' it will not start at all.
Any other ideas?
-Brian
----- Original Message -----
From: "Jean-Marc Paulin" <jmp@micromuse.com>
To: "Brian Babey" <bbabey@openroadsconsulting.com>; "pgsql-cygwin"
<pgsql-cygwin@postgresql.org>
Sent: Monday, August 12, 2002 4:12 AM
Subject: Re: [CYGWIN] 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@openroadsconsulting.com>
> To: "pgsql-cygwin" <pgsql-cygwin@postgresql.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
> >