Re: Hot standby hangs when restoring WAL files

On 02/11/2014 10:47 AM, Jürgen Fuchsberger wrote:
> 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
>
btw: PG-version is 9.1 under Debian Wheezy.

Juergen