Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDwr6-00057S-Mj for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 14:01:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WDwr6-0004bQ-5m for pgsql-admin@arkaria.postgresql.org; Thu, 13 Feb 2014 14:01:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDwr5-0004bK-Eh for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 14:01:31 +0000 Received: from mailout1.easymail.ca ([64.68.200.113] helo=mailout4.easymail.ca) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WDwqx-0001fh-Te for pgsql-admin@postgresql.org; Thu, 13 Feb 2014 14:01:31 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout4.easymail.ca (Postfix) with ESMTP id C28FEE1F7; Thu, 13 Feb 2014 09:01:20 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at mailout4.easymail.ca Received: from mailout4.easymail.ca ([127.0.0.1]) by localhost (easymail-mailout2.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id eK0yFRnLQbPe; Thu, 13 Feb 2014 09:01:14 -0500 (EST) Received: from [192.168.2.118] (174-16-19-159.hlrn.qwest.net [174.16.19.159]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by mailout4.easymail.ca (Postfix) with ESMTPSA id A6926E235; Thu, 13 Feb 2014 09:01:13 -0500 (EST) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\)) Subject: Re: Backup of shut down standby does not work? From: Scott Ribe In-Reply-To: <52FC8452.3090202@uni-graz.at> Date: Thu, 13 Feb 2014 07:01:08 -0700 Cc: pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: References: <52FC8452.3090202@uni-graz.at> To: =?iso-8859-1?Q?J=FCrgen_Fuchsberger?= X-Mailer: Apple Mail (2.1827) X-Pg-Spam-Score: -1.9 (-) 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 On Feb 13, 2014, at 1:37 AM, J=FCrgen Fuchsberger wrote: > So am I doing something wrong or are the WAL files really needed? If you're backing up a live server, and there is activity during the backup= ... You're missing step 1.5: select pg_start_backup('whatever') on the server. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin