BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown
Date
Msg-id 15742-44be3adfcd833cb8@postgresql.org
Whole thread Raw
Responses Re: BUG #15742: Postgres Service is not starting after Windowsabrupt Shutdown  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
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..


pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #15727: PANIC: cannot abort transaction 295144144, it wasalready committed
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15742: Postgres Service is not starting after Windowsabrupt Shutdown