Thread: BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown
BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 15742 Logged by: vinod viswanath Email address: vtvkerala@gmail.com PostgreSQL version: 9.6.7 Operating system: Microsoft Windows Server 2016 Standard Description: Due to a sudden power down, our PostGres server machine shut down abruptly. After rebooting, I tried to restart postgres and I get this error: 2019-04-03 14:06:05 IST FATAL: the database system is starting up 2019-04-03 14:06:06 IST FATAL: the database system is starting up 2019-04-03 14:06:40 IST LOG: database system was not properly shut down; automatic recovery in progress 2019-04-03 14:06:40 IST LOG: redo starts at A/5212A808 2019-04-03 14:06:57 IST LOG: invalid record length at A/52C87C68: wanted 24, got 0 2019-04-03 14:06:57 IST LOG: redo done at A/52C87C40 2019-04-03 14:06:57 IST LOG: last completed transaction was at log time 2019-04-03 13:58:49.502286+05:30 2019-04-03 14:06:58 IST LOG: MultiXact member wraparound protections are now enabled 2019-04-03 14:06:58 IST LOG: database system is ready to accept connections Is there any permanent solution for this, We are able to start the service after killing the postgres exes from task manager..
Re: BUG #15742: Postgres Service is not starting after Windowsabrupt Shutdown
From
Michael Paquier
Date:
On Tue, Apr 09, 2019 at 05:32:53AM +0000, PG Bug reporting form wrote: > Due to a sudden power down, our PostGres server machine shut down > abruptly. > After rebooting, I tried to restart postgres and I get this error: > [...] > 2019-04-03 14:06:58 IST LOG: database system is ready to accept > connections This last log entry means that PostgreSQL is up and running and that it has finished recovery. -- Michael