| From: | Jürgen Fuchsberger <juergen(dot)fuchsberger(at)uni-graz(dot)at> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Hot standby hangs when restoring WAL files |
| Date: | 2014-02-11 09:56:29 |
| Message-ID: | 52F9F3CD.3070906@uni-graz.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giuseppe Broccolo | 2014-02-11 12:00:23 | Re: [GENERAL] |
| Previous Message | Jürgen Fuchsberger | 2014-02-11 09:47:04 | Hot standby hangs when restoring WAL files |