Subject: Re: PostgreSQL: logon failure
From: Carlo Florendo <[email-masked]>
To: George <[email-masked]>
Cc: [email-masked]
Date: Fri, 17 Jun 2005 08:43:01 +0800

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@home 
>$ cygrunsrv -S cygserver
>
>postgres@home
>$ initdb -D /var/postgresql/data
>...
>
>george@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/