PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15742
PG Version9.6.7
OSMicrosoft Windows Server 2016 Standard
Opened2019-04-09 05:32:53+00
Reported byvinod viswanath
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15742
Logged by:          vinod viswanath
Email address:      (redacted)
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..

Messages

DateAuthorSubject
2019-04-09 05:32:53+00PG Bug reporting formBUG #15742: Postgres Service is not starting after Windows abrupt Shutdown
2019-04-09 06:54:50+00Michael PaquierRe: BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown