Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42177=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WDyPv-0000Gi-3s
 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 15:41:35 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42177=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WDyPu-0000gX-J8
 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 15:41:34 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <juergen.fuchsberger@uni-graz.at>) id 1WDyPs-0000ea-Or
 for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 15:41:32 +0000
Received: from ex07htca01.uni-graz.at ([143.50.13.79])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <juergen.fuchsberger@uni-graz.at>) id 1WDyPp-0007oW-JN
 for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 15:41:32 +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:41:26 +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:41:25 +0100
Message-ID: <52FCE7A4.4090400@uni-graz.at>
Date: Thu, 13 Feb 2014 16:41:24 +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: Scott Ribe <scott_ribe@elevated-dev.com>
CC: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Backup of shut down standby does not work?
References: <52FC8452.3090202@uni-graz.at>
 <EFC0F9A0-6115-45EF-9752-E24511EC7DEC@elevated-dev.com>
In-Reply-To: <EFC0F9A0-6115-45EF-9752-E24511EC7DEC@elevated-dev.com>
X-Enigmail-Version: 1.6
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="MFMro4cVPDTT1BEpgs78b0LgLS1fk4MIO"
X-Pg-Spam-Score: -3.3 (---)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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

On 02/13/2014 03:01 PM, Scott Ribe wrote:
> On Feb 13, 2014, at 1:37 AM, J=FCrgen Fuchsberger <juergen.fuchsberger@=
uni-graz.at> wrote:
>=20
>> So am I doing something wrong or are the WAL files really needed?
>=20
> If you're backing up a live server, and there is activity during the ba=
ckup...

I know, but I am backing up a shut down server.

Juergen
>=20
> You're missing step 1.5: select pg_start_backup('whatever') on the serv=
er.
>=20


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

iF4EAREIAAYFAlL856QACgkQ4RNsce5/DgDqDwD/eWi0/K3YsxYQeaydnC0tchw+
KjtVPaiodtbLyhOpqXcA/jpgjAegwQNDai6oJIWGesrBMFukMjyEPdLGRhkwEWuE
=3qiM
-----END PGP SIGNATURE-----

--MFMro4cVPDTT1BEpgs78b0LgLS1fk4MIO--