Windows Services and Postgresql 9.1.3 - Mailing list pgsql-admin

From Vincent Dautremont
Subject Windows Services and Postgresql 9.1.3
Date
Msg-id CAA4Vp4_LMVE8eTga6-cb=xDuwFoQ_o0X=UhgRESAgRRdVyCrMw@mail.gmail.com
Whole thread Raw
Responses Re: Windows Services and Postgresql 9.1.3
Re: Windows Services and Postgresql 9.1.3
List pgsql-admin
Hi,
I'm using Postgresql 9.1.3 x64 on Windows 2008,
I'm doing reliability tests and effects and consequences of a server power failure.

What I see is that when Windows reboots from a power failure sometimes the Windows postgresql service is not in sync with the actual state of postgres.

For example, after the server had rebooted, I would stop the service from services.msc
Windows then reports it as stopped but I can still see that the database is running,  and can use it.
When I would start the service again, I would end up with a timeout waiting for the service to be started. When in fact the database was always running.

Anyone had that bug/problem before ?

Thank You,
Vincent.



 

pgsql-admin by date:

Previous
From: Ronit Allen
Date:
Subject: pg_upgrade with postgis
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade with postgis