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:

[EMAIL PROTECTED] $ cygrunsrv -S cygserver

[EMAIL PROTECTED]
$ initdb -D /var/postgresql/data
...

[EMAIL PROTECTED]
$ 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/


Reply via email to