Re: postmaster service now fails to start under win2k - Mailing list pgsql-cygwin

Does your postgres user have read/write permissions on your data
directory?

Regards, Dave.

> -----Original Message-----
> From: Brian Babey [mailto:bbabey@openroadsconsulting.com]
> Sent: 12 August 2002 15:22
> To: Jean-Marc Paulin; pgsql-cygwin
> Subject: Re: [CYGWIN] postmaster service now fails to start
> under win2k
>
>
> 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
> > >
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>