Hot standby hangs when restoring WAL files

From: Jürgen Fuchsberger <juergen(dot)fuchsberger(at)uni-graz(dot)at>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Hot standby hangs when restoring WAL files
Date: 2014-02-11 09:47:04
Message-ID: 52F9F198.3060700@uni-graz.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jürgen Fuchsberger 2014-02-11 09:56:29 Re: Hot standby hangs when restoring WAL files
Previous Message Nedal Slman 2014-02-11 09:35:58