Re: 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(at)rec-all(dot)com>
>To: <pgsql-cygwin(at)postgresql(dot)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(at)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(at)rajesh ~
>> $ cygrunsrv -S ipc-daemon2
>>
>> rajesh(at)rajesh ~
>> $ cygrunsrv -S postmaster
>> cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error
>1062:
>> The service has not been started.
>>
>>
>> rajesh(at)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(at)rec-all(dot)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(at)postgresql(dot)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