Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 931A82E309E for ; Wed, 16 Jan 2008 04:09:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63954-02-6 for ; Wed, 16 Jan 2008 04:08:58 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 567B22E32CB for ; Wed, 16 Jan 2008 04:05:26 -0400 (AST) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m0G85WwO007828 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 16 Jan 2008 00:05:33 -0800 Message-ID: <478DBAC3.8050802@commandprompt.com> Date: Wed, 16 Jan 2008 00:05:23 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Brian Modra CC: pgsql-admin@postgresql.org Subject: Re: Backup of live database References: <5a9699850801152257g6ee9513i6c4fc88a5f20a785@mail.gmail.com> <478DAC1D.3010909@commandprompt.com> <5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com> In-Reply-To: <5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 16 Jan 2008 00:05:33 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/177 X-Sequence-Number: 27951 Brian Modra wrote: > The documentation about WAL says that you can start a live backup, as > long as you use WAL backup also. > I'm concerned about the integrity of the tar file. Can someone help me > with that? If you are using point in time recovery: http://www.postgresql.org/docs/8.2/static/continuous-archiving.html You do not have to worry about it. Joshua D. Drake > > On 16/01/2008, *Joshua D. Drake* > wrote: > > Brian Modra wrote: > > Hi, > > If tar reports that a file was modified while it was being archived, > > does that mean that the file was archived correctly, or is it > corrupted > > in the archive? > > Does tar take a snapshot of the file so that even if it is > modified, at > > least the archive is safe? > > You can not use tar to backup postgresql if it is running. > > http://www.postgresql.org/docs/8.2/static/backup.html > > > Sincerely, > > Joshua D. Drake > > > Thanks > > > > -- > > Brian Modra Land line: +27 23 5411 462 > > Mobile: +27 79 183 8059 > > 6 Jan Louw Str, Prince Albert, 6930 > > Postal: P.O. Box 2, Prince Albert 6930 > > South Africa > > > > > -- > Brian Modra Land line: +27 23 5411 462 > Mobile: +27 79 183 8059 > 6 Jan Louw Str, Prince Albert, 6930 > Postal: P.O. Box 2, Prince Albert 6930 > South Africa