X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 957E011F6620 for ; Wed, 29 Mar 2006 10:46:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96060-06 for ; Wed, 29 Mar 2006 10:46:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6E4AE11F6616 for ; Wed, 29 Mar 2006 10:46:33 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k2TEkUv6014905; Wed, 29 Mar 2006 09:46:30 -0500 (EST) To: andy.shellam@mailnetwork.co.uk cc: "'Rajesh Kumar Mallah'" , pgsql-admin@postgresql.org Subject: Re: FW: Setting up of PITR system. In-reply-to: References: Comments: In-reply-to "Andy Shellam" message dated "Wed, 29 Mar 2006 13:19:02 +0100" Date: Wed, 29 Mar 2006 09:46:30 -0500 Message-ID: <14904.1143643590@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200603/340 X-Sequence-Number: 21097 "Andy Shellam" writes: > If pg_start_backup is used correctly, no data pages will be written to disk > until pg_stop_backup is called, so this shouldn't be an issue That's incorrect, the database will continue to operate normally. The only thing pg_start_backup really does is lay down a marker so you can tell how far back you need to save WAL files in order to do a PITR restore using your backup. The fact that the backup tool might get an inconsistent copy of some files is not an issue, because replay of the WAL files against the copied database will fix any inconsistencies. It definitely is a pain in the neck that GNU tar complains about files changing underneath it --- I've looked for a way to disable that, or at least reduce it to a warning instead of an error condition, but gtar doesn't seem to have such a switch. You should try alternative backup tools such as cpio or rsync. regards, tom lane