Skip site navigation (1) Skip section navigation (2)

Re: cygrunsrv -S postmaster giving error

From: raj_14_11(at)rec-all(dot)com
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: cygrunsrv -S postmaster giving error
Date: 2003-09-08 12:35:13
Message-ID: Email.wozga8tVfdu@rec-all.com (view raw or flat)
Thread:
Lists: 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(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

Responses

pgsql-cygwin by date

Next:From: raj_14_11Date: 2003-09-08 12:50:49
Subject: (no subject)
Previous:From: George WeaverDate: 2003-09-08 12:30:39
Subject: Re: cygrunsrv -S postmaster giving error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group