Re: cygrunsrv -S postmaster giving error - Mailing list pgsql-cygwin
From | raj_14_11@rec-all.com |
---|---|
Subject | Re: cygrunsrv -S postmaster giving error |
Date | |
Msg-id | Email.wozga8tVfdu@rec-all.com Whole thread Raw |
In response to | cygrunsrv -S postmaster giving error (raj_14_11@rec-all.com) |
List | pgsql-cygwin |
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
pgsql-cygwin by date: