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
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 |