Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8D499B5DC1E for ; Sat, 10 Sep 2011 14:30:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55214-01 for ; Sat, 10 Sep 2011 17:30:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 3FAB5B5DC35 for ; Sat, 10 Sep 2011 14:30:49 -0300 (ADT) Received: from [192.168.10.3] (AMontsouris-552-1-71-123.w92-140.abo.wanadoo.fr [92.140.38.123]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id AE5DF3B8F5; Sat, 10 Sep 2011 19:30:48 +0200 (CEST) Subject: Re: Backup Question for Point-in-Time Recovery From: Guillaume Lelarge To: Rural Hunter Cc: pgsql-admin@postgresql.org Date: Sat, 10 Sep 2011 19:30:48 +0200 In-Reply-To: <4E6B9C2E.1060601@gmail.com> References: <4E6B9C2E.1060601@gmail.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.0.3 (3.0.3-1.fc15) Content-Transfer-Encoding: 7bit Message-ID: <1315675848.15665.11.camel@localhost.localdomain> Mime-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/53 X-Sequence-Number: 38290 On Sun, 2011-09-11 at 01:19 +0800, Rural Hunter wrote: > I'm making a base backup with 9.1rc by following 24.3.3 in manual: > http://www.postgresql.org/docs/9.1/static/continuous-archiving.html > 1. SELECT pg_start_backup('label'); > 2. perform file system backup with tar > 3. SELECT pg_stop_backup(); > > But when I was performing step 2, I got warning from tar command that > file was changed when tar was reading file on some files such as > 'postgres/base/16405/5659097'. Will I get a good backup in this case? > Yes. But note that you can use pg_basebackup in 9.1. It does everything needed to have a complete file backup. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com