Re: BUG #9756: Inconsistent database after OS restart

On Fri, Mar 28, 2014 at 12:58 AM, <sdl(at)mnppsaturn(dot)ru> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 9756
> Logged by: Dmitry Samokhin
> Email address: sdl(at)mnppsaturn(dot)ru
> PostgreSQL version: 9.2.8
> Operating system: Windows XP, 7
> Description:
>
> After every Windows restart, database couldn't be shut down properly and
> recovering actions are performed on the next startup. But if we control the
> service manually by the Windows Services snap-in, no problem with the
> correct DB cluster shutdown. Looks like there's something wrong with the
> correct autovacuum process shutdown which leads to the DB inconsistency.
>
>
> *** Windows restart: ***
>
> -- Stopping:
> 2014-03-28 11:37:34 MSK LOG: received fast shutdown request
> 2014-03-28 11:37:34 MSK LOG: aborting any active transactions
> 2014-03-28 11:37:34 MSK LOG: autovacuum launcher shutting down
> 2014-03-28 11:37:34 MSK ERROR: canceling statement due to user request
>

It looks like Windows told the server to shutdown, but did not give it
enough time to complete the process before killing it uncleanly.

Can you make Windows shutdown more patient?

Cheers,

Jeff