Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 72538B5DBFC for ; Sat, 10 Sep 2011 22:17:37 -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 65863-10 for ; Sun, 11 Sep 2011 01:17:31 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com [209.85.210.42]) by mail.postgresql.org (Postfix) with ESMTP id D1402B5DBC5 for ; Sat, 10 Sep 2011 22:17:30 -0300 (ADT) Received: by pzk37 with SMTP id 37so6483274pzk.15 for ; Sat, 10 Sep 2011 18:17:30 -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:cc:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=JRPpME0W49o92Ml/nk5KPIszGHN3/WQtgJcb1Tk8wAs=; b=eiUCzakuKDFhChc17+v9ROlxgP0p2SkaX9gGMtKlN11vY4gdlDZeyFwuygHRKt93ai CSuUteejcGukxsbp6YGGW7wpYON8td9ilsurUTnZydZ8nY8OQHmwhS8a5VSs3cwLDTNt xCg7ryXQ7tgiu+z+3vufC1wHyM39qSNZ9dLaY= Received: by 10.68.58.136 with SMTP id r8mr1532058pbq.145.1315703850760; Sat, 10 Sep 2011 18:17:30 -0700 (PDT) Received: from [192.168.11.3] ([114.85.164.53]) by mx.google.com with ESMTPS id z1sm31436141pbz.6.2011.09.10.18.17.26 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 10 Sep 2011 18:17:29 -0700 (PDT) Message-ID: <4E6C0C19.5080502@gmail.com> Date: Sun, 11 Sep 2011 09:17:13 +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 CC: pgsql-admin@postgresql.org Subject: Re: Backup Question for Point-in-Time Recovery References: <4E6B9C2E.1060601@gmail.com> <1315675848.15665.11.camel@localhost.localdomain> In-Reply-To: <1315675848.15665.11.camel@localhost.localdomain> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.868 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, MISSING_HEADERS=1.021, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201109/55 X-Sequence-Number: 38292 OK, thank you. 于2011年9月11日 1:30:48,Guillaume Lelarge写到: > 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. > >