Re: cygrunsrv -S postmaster giving error - Mailing list pgsql-cygwin

From George Weaver
Subject Re: cygrunsrv -S postmaster giving error
Date
Msg-id 009b01c37610$cc10c030$fd09a18e@cleartag
Whole thread Raw
In response to Re: cygrunsrv -S postmaster giving error  (raj_14_11@rec-all.com)
List pgsql-cygwin
Rajesh,

In the Properties window for the Postmaster service (Windows Services -
usually Services under Administrative Tools or the equivalent), go to the
Log On tab and make sure the option "This account: " is selected.  Enter the
appropriate user name and password that you are using to start postmaster
under Cygrunsrv (i.e. enter the same user name and password in you Cygrunsrv
command line).  You will have to log on to Windows using this user name and
password, and then run Cygrunsrv.  If successful, it should then start
automatically whenever you boot up.

Once it starts as a service, if you have problems with it not starting in
the future on boot up, make sure there is no postmaster.pid file in the
database directory.  If postmaster is NOT running, and there is a
postmaster.pid file in the directory, delete the file and try to start the
service again.

HTH.
George

----- Original Message -----
From: <raj_14_11@rec-all.com>
To: <pgsql-cygwin@postgresql.org>
Sent: Monday, September 08, 2003 7:35 AM
Subject: Re: [CYGWIN] cygrunsrv -S postmaster giving error


>
> There is no file "postmaster.pid" i have ever found.
> and how to start postmaster asservice with username and password ?
> thx,
> Rajesh
> >
> >My experience with starting postmaster as a service under Windows is that
> >you MUST use a password with the login name.  Also make sure that there
is
> >no remnant "postmaster.pid" file in your database directory when you try
to
> >start postmaster as a service.
> >
> >George
> >
> >----- Original Message -----
> >From: <raj_14_11@rec-all.com>
> >To: <pgsql-cygwin@postgresql.org>
> >Sent: Monday, September 08, 2003 6:59 AM
> >Subject: Re: [CYGWIN] cygrunsrv -S postmaster giving error
> >
> >
> >> This is what i am doing logged in as user belonging to the local
> >administrator group and using ipc-daemon2 during install, still getting
the
> >error.
> >> ********************************************
> >> rajesh@rajesh ~
> >> $ cygrunsrv --install postmaster --desc "PostgreSQL Database
> >Server" --path /
> >> r/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep
> >ipc-daemon2
> >> termsig INT --user postgres --shutdown --stdout /pgsql.log --stderr
> >/pgsql.er
> >> Enter password of user `RAJESH\postgres':
> >> Reenter, please:
> >>
> >> rajesh@rajesh ~
> >> $ cygrunsrv -S ipc-daemon2
> >>
> >> rajesh@rajesh ~
> >> $ cygrunsrv -S postmaster
> >> cygrunsrv: Error starting a service: QueryServiceStatus:  Win32 error
> >1062:
> >> The service has not been started.
> >>
> >>
> >> rajesh@rajesh ~
> >> $ cygrunsrv -Q postmaster
> >> Service postmaster exists
> >> Type                : Own Process
> >> Current State       : Stopped
> >> Controls Accepted   :
> >>
> >> ********************************************
> >>
> >> >On Mon, Sep 08, 2003 at 06:16:48PM +0700, raj_14_11@rec-all.com wrote:
> >> >> ipc-daemon2 is running....
> >> >> still i am getting the error.
> >> >> and if i run
> >> >> ********************************
> >> >> $ cygrunsrv -Q postmaster
> >> >> Service postmaster exists
> >> >> Type                : Own Process
> >> >> Current State       : Stopped
> >> >> Controls Accepted   :
> >> >> ********************************
> >> >
> >> >Is postmaster dependent on ipc-daemon2 or ipc-daemon?
> >> >
> >> >> i get this.
> >> >> those fix packs as mentioned in the link apply to NT,I am using
windows
> >2000
> >> >
> >> >I meant the Administrator part.  Are you starting the service when
> >> >logged into an account that is part of the local Administrators group?
> >> >
> >> >Jason
> >> >
> >> >--
> >> >PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> >> >Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6
> >> >
> >> >---------------------------(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
> >>
> >> ---------------------------------------------
> >> WWW.rec-all.com - a community of all the RECs
> >>
> >> ---------------------------(end of
broadcast)---------------------------
> >> TIP 8: explain analyze is your friend
> >>
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 9: the planner will ignore your desire to choose an index scan if
your
> >      joining column's datatypes do not match
>
> ---------------------------------------------
> WWW.rec-all.com - a community of all the RECs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


pgsql-cygwin by date:

Previous
From: raj_14_11@rec-all.com
Date:
Subject: Re: cygrunsrv -S postmaster giving error
Next
From: Patrick Bakker
Date:
Subject: Re: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22,