Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <42B21C95.9090800@hq.astra.ph>
Date: Fri, 17 Jun 2005 08:43:01 +0800
From: Carlo Florendo <list-subscriber AT hq DOT astra DOT ph>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7) Gecko/20040616
MIME-Version: 1.0
To: George <d1945 AT sbcglobal DOT net>
Cc: cygwin AT cygwin DOT com
Subject: Re: PostgreSQL: logon failure
References: <20050616150739 DOT GA1248 AT home> <42B1D134 DOT 40802 AT x-ray DOT at> <20050616221242 DOT GA1184 AT home>
In-Reply-To: <20050616221242.GA1184@home>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

George wrote:

>On Thu, Jun 16, 2005 at 09:21:24PM +0200, Reini Urban schrieb:
>  
>
>>George schrieb:
>>    
>>
>>>I followed the instructions for installing postgresql as an NT service
>>>as outlined in the postgresql README, but ended up with the following
>>>error: 
>>>
>>>$ cygrunsrv -S postmaster
>>>cygrunsrv: Error starting a service: StartService:  Win32 error 1069:
>>>The service did not start due to a logon failure.
>>>      
>>>
>>As what user do you start the service?
>>The service could not logon as this user.
>>    
>>
>
>Makes perfect sense, but I simply followed the instructions in the
>README which were fairly straightforward:
>
>george AT home 
>$ cygrunsrv -S cygserver
>
>postgres AT home
>$ initdb -D /var/postgresql/data
>...
>
>george AT home
>$ cygrunsrv -S postmaster
>cyrunsrv: Error ...
>
>  
>

Your initdb is started with user "postgresql".  Postmaster is started 
with user "george".  Why not run initdb and and "cygrunsrv -S 
postmaster" under the same user?  Then, when setting up postmaster from 
cygrunsrv, specify the user you choose.

Under user george, you may:

1. Remove the old service:
cygrunsrv -R postmaster   # removes the service

2. Reinstall the new service
cygrunsrv --install postmaster --path /usr/bin/postmaster \
    --args "-D /var/postgresql/data -i" --dep cygserver \
    --user george --termsig INT -e "CYGWIN=server" --shutdown

3. Clear the database directory, then, (still under user george)

initdb -D /var/postgresql/data

4.  Run the service

cygrunsrv -S postmaster


HTH.

Thank you very much.

Best Regards,

Carlo


-- 
Carlo Florendo
Astra Philippines Inc.
www.astra.ph


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/