Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A20D5B5DC1F for ; Sat, 10 Sep 2011 14:20:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 32304-03 for ; Sat, 10 Sep 2011 17:20:02 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yi0-f46.google.com (mail-yi0-f46.google.com [209.85.218.46]) by mail.postgresql.org (Postfix) with ESMTP id 15DB4B5DC0C for ; Sat, 10 Sep 2011 14:20:01 -0300 (ADT) Received: by yie30 with SMTP id 30so1689752yie.19 for ; Sat, 10 Sep 2011 10:20:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=D5XLj+3VGGUBlcWE/ASeuctfuq3+sIjFfYc6lNZ3udc=; b=RcJjIWcU3pB2H+hvLnRZz1MtVFD4Rm4YEGWMq9pVhpe0B/91Mhxtk14DvSOcm64ajo FHJ9YpFDegBwQb5S2G2xWtzp32HAL00Olc85OTQknIaNcVfTtbUr9R17PTYpgYXCL5uK cqsmRYAj1auEJsKXiu3H9xvp4m9AEqLFl83Eg= Received: by 10.68.199.165 with SMTP id jl5mr1677807pbc.104.1315675201118; Sat, 10 Sep 2011 10:20:01 -0700 (PDT) Received: from [192.168.11.3] ([116.225.155.222]) by mx.google.com with ESMTPS id x6sm28807857pba.5.2011.09.10.10.19.56 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 10 Sep 2011 10:19:59 -0700 (PDT) Message-ID: <4E6B9C2E.1060601@gmail.com> Date: Sun, 11 Sep 2011 01:19:42 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Backup Question for Point-in-Time Recovery Content-Type: text/plain; charset=GB18030; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.889 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201109/52 X-Sequence-Number: 38289 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?