Обсуждение: cygrunsrv -S postmaster giving error
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
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
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
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
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
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
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 >
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
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
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
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 >