BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15742
Logged by:          vinod viswanath
Email address:      [hidden email]
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..

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15742: Postgres Service is not starting after Windows abrupt Shutdown

Michael Paquier-2
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

signature.asc (849 bytes) Download Attachment