From: Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
To: pgsql-admin@postgresql.org
Subject: Hot standby hangs when restoring WAL files
Date: Tue, 11 Feb 2014 10:47:04 +0100
Message-ID: <52F9F198.3060700@uni-graz.at> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
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: <52F9F198.3060700@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