Message-ID: <52FC8452.3090202@uni-graz.at>
Date: Thu, 13 Feb 2014 09:37:38 +0100
From: =?ISO-8859-1?Q?J=FCrgen_Fuchsberger?= <juergen.fuchsberger@uni-graz.at>
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@postgresql.org>
Subject: Backup of shut down standby does not work?
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="GdbVvVw5RgTqXgMGhC1RPVDBjmaE2022f"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--GdbVvVw5RgTqXgMGhC1RPVDBjmaE2022f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,

I have a master-slave configuration running the master with WAL
archiving enabled and the slave in recovery mode reading back the WAL
files from the master (as described in
http://www.postgresql.org/docs/9.1/static/continuous-archiving.html#BACKU=
P-PITR-RECOVERY

Now I am doing the following backup strategy:

1) Stop slave (fast shutdown).
2) Rsync to backup fileserver
3) Start slave.

I just tried to recover a Backup which *failed* with the following errors=
:

2014-02-13 08:34:05 CET LOG:  starting archive recovery
2014-02-13 08:34:05 CET LOG:  incomplete startup packet
cp: cannot stat `/var/postgres-wal/00000001000001E300000061': No such
file or directory
2014-02-13 08:34:05 CET LOG:  could not open file
"pg_xlog/00000001000001E300000061" (log file 483, segment 97): No such
file or directory
2014-02-13 08:34:05 CET LOG:  invalid primary checkpoint record
cp: cannot stat `/var/postgres-wal/00000001000001E300000060': No such
file or directory
2014-02-13 08:34:05 CET LOG:  could not open file
"pg_xlog/00000001000001E300000060" (log file 483, segment 96): No such
file or directory
2014-02-13 08:34:05 CET LOG:  invalid secondary checkpoint record
2014-02-13 08:34:05 CET PANIC:  could not locate a valid checkpoint recor=
d
2014-02-13 08:34:06 CET FATAL:  the database system is starting up
2014-02-13 08:34:06 CET FATAL:  the database system is starting up
2014-02-13 08:34:07 CET FATAL:  the database system is starting up
2014-02-13 08:34:07 CET FATAL:  the database system is starting up
2014-02-13 08:34:07 CET LOG:  startup process (PID 16882) was terminated
by signal 6: Aborted
2014-02-13 08:34:08 CET LOG:  aborting startup due to startup process
failure

So it seems the server is missing the archived WAL files which are not
in the backup. Some time ago there was a discussion about this
(http://www.postgresql.org/message-id/CAFwQ8rd+oDkLG4KWkux=3D2jwNinBnuwhY=
8DH3W-_58MGO1m3=3DLg@mail.gmail.com)
and it turned out that the WAL archive is not needed, only files in
pg_xlog which I *did* backup.

So am I doing something wrong or are the WAL files really needed?

Best,
Juergen


--GdbVvVw5RgTqXgMGhC1RPVDBjmaE2022f
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/

iF4EAREIAAYFAlL8hFIACgkQ4RNsce5/DgBQTQD9EqszSj31BEbvCa3M4hndEDRg
fhTZwZ7dMfTBtMzgtAwA/0EF/IYSfWSX3R5ZopkMUCKp/8qmxe+K2xMCAImIJbob
=KfxA
-----END PGP SIGNATURE-----

--GdbVvVw5RgTqXgMGhC1RPVDBjmaE2022f--