Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDA50-0003R4-R3 for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2014 09:56:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WDA50-00085e-Ah for pgsql-admin@arkaria.postgresql.org; Tue, 11 Feb 2014 09:56:38 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDA4z-00085X-5C for pgsql-admin@postgresql.org; Tue, 11 Feb 2014 09:56:37 +0000 Received: from ex07htca01.uni-graz.at ([143.50.13.79]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDA4w-00010x-EJ for pgsql-admin@postgresql.org; Tue, 11 Feb 2014 09:56:36 +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:56:31 +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:56:30 +0100 Message-ID: <52F9F3CD.3070906@uni-graz.at> Date: Tue, 11 Feb 2014 10:56:29 +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: Re: Hot standby hangs when restoring WAL files References: <52F9F198.3060700@uni-graz.at> In-Reply-To: <52F9F198.3060700@uni-graz.at> X-Enigmail-Version: 1.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="C95OHQDJAm7B434wEis51urRjtAVjBdo2" 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 --C95OHQDJAm7B434wEis51urRjtAVjBdo2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 02/11/2014 10:47 AM, J=FCrgen Fuchsberger wrote: > Hi, >=20 > After my Master server hanged I have problems with my Standby: It > repeats trying to restore the same WAL file all the time: >=20 > 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 >=20 > What can I do? >=20 > (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?) >=20 > Best, > Juergen >=20 btw: PG-version is 9.1 under Debian Wheezy. Juergen --C95OHQDJAm7B434wEis51urRjtAVjBdo2 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/ iF4EAREIAAYFAlL5880ACgkQ4RNsce5/DgDmOAD/aswRPG4As+UEm/FWlXHir5eR L9BvcZe6MqtU0gfJQt4A/i7ibiVKcqfmosoIMg09Mrk+j4MBy00zALD3CJg4ocdO =TZdA -----END PGP SIGNATURE----- --C95OHQDJAm7B434wEis51urRjtAVjBdo2--