BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown
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..
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