Thread: cygrunsrv -S postmaster giving error

cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
Hi,
as per jason's directive i did all the steps but its giving error at this point
*****************************
$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: StartService:  Win32 error 1068:
The dependency service or group failed to start.
*****************************
can anybodu help me whats wrong ?

thx
Rajesh.
---------------------------------------------
WWW.rec-all.com - a community of all the RECs

Re: cygrunsrv -S postmaster giving error

From
Jason Tishler
Date:
Rajesh,

On Mon, Sep 08, 2003 at 05:23:50PM +0700, raj_14_11@rec-all.com wrote:
> as per jason's directive i did all the steps but its giving error at
> this point
> *****************************
> $ cygrunsrv -S postmaster
> cygrunsrv: Error starting a service: StartService:  Win32 error 1068:
> The dependency service or group failed to start.
> *****************************
> can anybodu help me whats wrong ?

postmaster is failing to start because one of its dependencies (i.e.,
ipc-daemon2) is failing to start.  Fix your ipc-daemon2 problems and
postmaster should start up OK.  Hopefully, my previous email will be
helpful.

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

Re: cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
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   :
********************************

i get this.
those fix packs as mentioned in the link apply to NT,I am using windows 2000
>Rajesh,
>
>On Mon, Sep 08, 2003 at 05:23:50PM +0700, raj_14_11@rec-all.com wrote:
>> as per jason's directive i did all the steps but its giving error at
>> this point
>> *****************************
>> $ cygrunsrv -S postmaster
>> cygrunsrv: Error starting a service: StartService:  Win32 error 1068:
>> The dependency service or group failed to start.
>> *****************************
>> can anybodu help me whats wrong ?
>
>postmaster is failing to start because one of its dependencies (i.e.,
>ipc-daemon2) is failing to start.  Fix your ipc-daemon2 problems and
>postmaster should start up OK.  Hopefully, my previous email will be
>helpful.
>
>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

---------------------------------------------
WWW.rec-all.com - a community of all the RECs

Re: cygrunsrv -S postmaster giving error

From
Jason Tishler
Date:
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

Re: cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
a. postmaster is dependent on ipc-daemon
b. i am not logged in as into an account that is part of the local Administrators group.

>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

Re: cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
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

Re: cygrunsrv -S postmaster giving error

From
"George Weaver"
Date:
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
>


Re: cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
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

Re: cygrunsrv -S postmaster giving error

From
Jason Tishler
Date:
On Mon, Sep 08, 2003 at 06:48:40PM +0700, raj_14_11@rec-all.com wrote:
> a. postmaster is dependent on ipc-daemon

The latest PostgreSQL (i.e., 7.3.4-2) requires postmaster to be
dependent on ipc-daemon2 not ipc-daemon.

> b. i am not logged in as into an account that is part of the local
> Administrators group.

The above is probably a non-issue, but one of your error messages seems
to indicate otherwise...

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

Re: cygrunsrv -S postmaster giving error

From
raj_14_11@rec-all.com
Date:
still same error :-(

>On Mon, Sep 08, 2003 at 06:48:40PM +0700, raj_14_11@rec-all.com wrote:
>> a. postmaster is dependent on ipc-daemon
>
>The latest PostgreSQL (i.e., 7.3.4-2) requires postmaster to be
>dependent on ipc-daemon2 not ipc-daemon.
>
>> b. i am not logged in as into an account that is part of the local
>> Administrators group.
>
>The above is probably a non-issue, but one of your error messages seems
>to indicate otherwise...
>
>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

---------------------------------------------
WWW.rec-all.com - a community of all the RECs

Re: cygrunsrv -S postmaster giving error

From
"George Weaver"
Date:
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
>