Postgres Pro
Downloads
Home   >   mailing lists

Hot standby hangs when restoring WAL files - Mailing list pgsql-admin

From Jürgen Fuchsberger
Subject Hot standby hangs when restoring WAL files
Date
Msg-id 52F9F198.3060700@uni-graz.at
Whole thread Raw
Responses Re: Hot standby hangs when restoring WAL files
List pgsql-admin
Tree view 
Hi,

After my Master server hanged I have problems with my Standby: It
repeats trying to restore the same WAL file all the time:

2014-02-11 10:19:20 CET LOG:  invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:25 CET LOG:  restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:25 CET LOG:  invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:30 CET LOG:  restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:30 CET LOG:  invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:36 CET LOG:  restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:36 CET LOG:  invalid record length at 2B3/E6F9C40C

What can I do?

(I do keep a Backup of my WAL files a week back or so, so maybe I can
just try to start recovery at an earlier point?)

Best,
Juergen
Attachment

pgsql-admin by date:

Previous
From: desmodemone
Date:
Subject: Re: Replica (v 9.3.2) crashed with "PANIC: WAL contains references to invalid pages"
Next
From: Jürgen Fuchsberger
Date:
Subject: Re: Hot standby hangs when restoring WAL files