Hi Daya;
To install postgresql as a service in XP it must be started by a user with a
password, and the password can't be blank. Make sure you define a user name
and password in the cygrunsrv command when you install postgresql as a
service. If a postmaster.log file exists in "c:\cygwin\var\log" directory,
delete or rename it (this assumes that you've named the service
"postmaster"). Then go to the services menu (Start > Settings > Control
Panel > Administrative Tools > Services), and locate the postmaster service
in the listing of services. Right click on the postmaster service and
choose Properties, then the "Log on" tab. Choose "This account:" and enter
the appropriate login name and password. If you started XP with this user
name and id, you should now be able to start the service. If you haven't
started XP with this user name and password, do so, and the service should
start automatically when you log in.
HTH
George
----- Original Message -----
From: "Daya Kiran Sunkara" <sdayakiran@yahoo.com>
To: <pgsql-cygwin@postgresql.org>
Sent: Friday, March 14, 2003 5:34 AM
Subject: [CYGWIN] postgresql on windows xp
> Hi
> After a lot of efforts I have installed postgresql
> over cygwin in windows xp. But when i try to start the
> service, it starts and stops automatically. I get the
> following message
> "The postgresql service on the local computer started
> and stopped. some services stop automatically if they
> have no work to do, for example the performance logs
> and alerts services"
>
> I have added the windows default alerter as a
> dependency for the postmaster service. but even then i
> get the same message. Does anyone know how i could fix
> this problem
> Bye
> Daya kiran
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>