Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDyRG-0000IC-97 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 15:42:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WDyRF-0002Bt-OU for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 15:42:57 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDyRE-0002Af-Mz for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 15:42:56 +0000 Received: from ex07htca01.uni-graz.at ([143.50.13.79]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDyR7-0007ow-Kc for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 15:42:56 +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; Thu, 13 Feb 2014 16:42:48 +0100 Received: from [192.168.2.112] (143.50.203.87) by ex07htca03.pers.ad.uni-graz.at (143.50.13.85) with Microsoft SMTP Server (TLS) id 8.3.342.0; Thu, 13 Feb 2014 16:42:48 +0100 Message-ID: <52FCE7F7.5070801@uni-graz.at> Date: Thu, 13 Feb 2014 16:42:47 +0100 From: =?ISO-8859-2?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: pgsql-admin Subject: Re: Backup of shut down standby does not work? References: <52FC8452.3090202@uni-graz.at> <3A292C84467D6F41BB43EE514A36E232ACC14B05@DOMACI22.intranet2.srce.hr> In-Reply-To: <3A292C84467D6F41BB43EE514A36E232ACC14B05@DOMACI22.intranet2.srce.hr> X-Enigmail-Version: 1.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="gwu7qIihJwJcCJo8TiTrNNB7FRl2lEbhC" X-Pg-Spam-Score: -3.3 (---) 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 --gwu7qIihJwJcCJo8TiTrNNB7FRl2lEbhC Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable On 02/13/2014 10:07 AM, Dubravko Sever wrote: > Hi, >=20 > Do you have recovery.conf and archive command well defined?. Becaus= e restore command look for wall files located on slave inside of `/var/= postgres-wal/.=20 >=20 > Dubravko >=20 Yes, the config is correct. The only problem is the missing files in /var/postgres-wal (which I expected not to be needed). I think it should work without the recovery.conf too (since I expect the backup to be consistent) , which results in this error: 2014-02-13 11:14:49 CET LOG: incomplete startup packet 2014-02-13 11:14:49 CET LOG: database system was shut down in recovery at 2013-12-25 18:00:03 CET 2014-02-13 11:14:49 CET LOG: could not open file "pg_xlog/00000001000001E300000061" (log file 483, segment 97): No such file or directory 2014-02-13 11:14:49 CET LOG: invalid primary checkpoint record 2014-02-13 11:14:49 CET LOG: could not open file "pg_xlog/00000001000001E300000060" (log file 483, segment 96): No such file or directory 2014-02-13 11:14:49 CET LOG: invalid secondary checkpoint record 2014-02-13 11:14:49 CET PANIC: could not locate a valid checkpoint recor= d 2014-02-13 11:14:49 CET FATAL: the database system is starting up 2014-02-13 11:14:50 CET FATAL: the database system is starting up 2014-02-13 11:14:53 CET FATAL: the database system is starting up 2014-02-13 11:14:53 CET FATAL: the database system is starting up 2014-02-13 11:14:54 CET LOG: startup process (PID 8277) was terminated by signal 6: Aborted 2014-02-13 11:14:54 CET LOG: aborting startup due to startup process failure Juergen. --gwu7qIihJwJcCJo8TiTrNNB7FRl2lEbhC 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/ iF4EAREIAAYFAlL85/cACgkQ4RNsce5/DgAfgQD8CFUNimrcsXiXP0g+S5swHQxx NzavuVChZydMvvc4s2EBAJRYVcEbYQ3w6SaQU4hHVNT+pBkx5DrwgWifJVAhA1Gt =lWIM -----END PGP SIGNATURE----- --gwu7qIihJwJcCJo8TiTrNNB7FRl2lEbhC--