Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WD9vw-00037t-Hg for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2014 09:47:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WD9vw-0005zF-2G for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2014 09:47:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WD9vu-0005z8-Vq for pgsql-admin@postgresql.org; Tue, 11 Feb 2014 09:47:15 +0000 Received: from ex07htca01.uni-graz.at ([143.50.13.79]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WD9vr-0004VQ-RY for pgsql-admin@postgresql.org; Tue, 11 Feb 2014 09:47:14 +0000 Received: from ex07htca03.pers.ad.uni-graz.at (2002:8f32:d55::8f32:d55) by ex07htca01.pers.ad.uni-graz.at (2002:8f32:d4f::8f32:d4f) with Microsoft SMTP Server (TLS) id 8.3.342.0; Tue, 11 Feb 2014 10:47:10 +0100 Received: from [192.168.2.112] (143.50.203.90) by ex07htca03.pers.ad.uni-graz.at (143.50.13.85) with Microsoft SMTP Server (TLS) id 8.3.342.0; Tue, 11 Feb 2014 10:47:10 +0100 Message-ID: <52F9F198.3060700@uni-graz.at> Date: Tue, 11 Feb 2014 10:47:04 +0100 From: =?ISO-8859-1?Q?J=FCrgen_Fuchsberger?= Organization: Wegener Center for Climate and Global Change User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/20131104 Icedove/17.0.10 MIME-Version: 1.0 To: Subject: Hot standby hangs when restoring WAL files X-Enigmail-Version: 1.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="EiI1Xhuq7WOB2UvSojCUEoaXqoJd2evLN" X-Pg-Spam-Score: -3.2 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --EiI1Xhuq7WOB2UvSojCUEoaXqoJd2evLN Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 --EiI1Xhuq7WOB2UvSojCUEoaXqoJd2evLN Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iF4EAREIAAYFAlL58Z0ACgkQ4RNsce5/DgDsLAEAocsfyyQ1uX/xKhiLk9VL3T6t cKkCsSf41csD2tDrqsIA/2p9CI69sFA68UQW3qCUlf/As7cAa+gpRm86f/KFyLD0 =Rk0K -----END PGP SIGNATURE----- --EiI1Xhuq7WOB2UvSojCUEoaXqoJd2evLN--