Re: postmaster service now fails to start under win2k

Hello Brian,

Have you tried starting your service using "cygrunsrv ... --stderr <your log
file>" (where <your log file> is any file where the user launching the
service can read/write) ? There is much useful information about why
postmaster would fail starting is this file (such as directory permission
errors, lock file errors, and so on).

Hope it might help.

Cedric Dufour

> -----Original Message-----
> From: pgsql-cygwin-owner(at)postgresql(dot)org
> [mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of Dave Page
> Sent: Monday, August 12, 2002 16:25
> To: Brian Babey; Jean-Marc Paulin; pgsql-cygwin
> Subject: Re: [CYGWIN] postmaster service now fails to start under win2k
>
>
> Does your postgres user have read/write permissions on your data
> directory?
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: Brian Babey [mailto:bbabey(at)openroadsconsulting(dot)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(at)micromuse(dot)com>
> > To: "Brian Babey" <bbabey(at)openroadsconsulting(dot)com>;
> > "pgsql-cygwin" <pgsql-cygwin(at)postgresql(dot)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(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 4: Don't 'kill -9' the postmaster
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>