Hi, Thanks for all the responses. From the event viewer what I got was that the service was failing b'cos it thought that the database was already and locked by a postmaster.pid file. Just deleting that file helped. Now, the service has started and a new postmaster.pid file has been created. For now, I'm all set, although I'd be curious how I could have gotten into this situation.
best, -k
> Date: Fri, 11 Apr 2008 15:31:37 +0200 > From: haraldarminmassa@gmail.com > To: kalyan_v@hotmail.com > Subject: Re: [pgadmin-support] windows service not working > CC: pgadmin-support@postgresql.org > > Kalyan, > > > Hi, > > I just installed postgresql 8.3 on my windows xp desktop. For some > > reason, I am not able to start it as a service from the control panel (I > > have set it to start manually). But if I bring up pgAdmin III UI, I can > > connect to the db from there. > > > if you can connect to the database, there is something running. Either > the database not as a service, or something else. > > So, propably your service fails to start because the port 5432 > (propably the default) is still in use. > > you should fire up eventvwr and check the application log. There you > may find more about the reason why you cannot start your service. > > Also have a look at $PGDATA/pg_log (default below > PostgreSQL/8.3/data), if anything is written there. > > best wishes > > Harald > > > > > -- > GHUM Harald Massa > persuadere et programmare > Harald Armin Massa > Spielberger Straße 49 > 70435 Stuttgart > 0173/9409607 > fx 01212-5-13695179 > - > EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
