Re: windows service not working

From: Kalyan Vaidyanathan <kalyan_v(at)hotmail(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: windows service not working
Date: 2008-04-12 01:21:47
Message-ID: BAY138-W521CFE3183C0818BAE157FF6EE0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)gmail(dot)com
> To: kalyan_v(at)hotmail(dot)com
> Subject: Re: [pgadmin-support] windows service not working
> CC: pgadmin-support(at)postgresql(dot)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!

_________________________________________________________________
Going green? See the top 12 foods to eat organic.
http://green.msn.com/galleries/photos/photos.aspx?gid=164&ocid=T003MSN51N1653A

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Julius Tuskenis 2008-04-14 13:27:08 BUG: adding column of type timestamp with time zone
Previous Message Harald Armin Massa 2008-04-11 13:31:37 Re: windows service not working