From: Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
To: pgsql-admin@postgresql.org
Subject: Re: Hot standby hangs when restoring WAL files
Date: Tue, 11 Feb 2014 10:56:29 +0100
Message-ID: <52F9F3CD.3070906@uni-graz.at> (raw)
In-Reply-To: <52F9F198.3060700@uni-graz.at>
References: <52F9F198.3060700@uni-graz.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Attachments:
signature.asc (application/pgp-signature, 290B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: juergen.fuchsberger@uni-graz.at
Subject: Re: Hot standby hangs when restoring WAL files
In-Reply-To: <52F9F3CD.3070906@uni-graz.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox