Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0ED2E2E095C for ; Wed, 16 Jan 2008 03:10:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05773-10 for ; Wed, 16 Jan 2008 03:10:41 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id B22F72E079B for ; Wed, 16 Jan 2008 03:10:43 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d37so265552pye.29 for ; Tue, 15 Jan 2008 23:10:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=+qxQGuQ1s2iM2KUcOfdcKb8QYSPkxqJDYbYBhyVcpHk=; b=bZczIijE2W5mUlQynMcryRB17Ls8PTC5U4YutR8dkKMtuZmZ/LRKshqcidzYRrXW/+wVO9LQlRljj6/7b4++kTI3Gp4gchp/9zuYOtUHNkk4ZbzEklnyM6Y3/Cro5iUI8aYhbGP1AtNFxzBWv/1o6cfT4b5wLxP777pw7A83epA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Jqj8DQlyTQ0EJhQD0YuIZpySGBR+wVo8Zt3XBZS+pkH8eWFUNndkk7Y3vmrWeLM3NYm2pAqB8xt7+jSbiy3JAg/f35e+e3PLIjQHtus8mReXtvt60zLzgV3EzwbFQLRAYOVjqCyMYIxGv9vrUx5JUws68G4M1dVysXS+0S6/msQ= Received: by 10.35.116.12 with SMTP id t12mr492339pym.52.1200467442134; Tue, 15 Jan 2008 23:10:42 -0800 (PST) Received: by 10.35.72.8 with HTTP; Tue, 15 Jan 2008 23:10:42 -0800 (PST) Message-ID: <5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com> Date: Wed, 16 Jan 2008 09:10:42 +0200 From: "Brian Modra" To: "Joshua D. Drake" Subject: Re: Backup of live database Cc: pgsql-admin@postgresql.org In-Reply-To: <478DAC1D.3010909@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19428_7605376.1200467442129" References: <5a9699850801152257g6ee9513i6c4fc88a5f20a785@mail.gmail.com> <478DAC1D.3010909@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/174 X-Sequence-Number: 27948 ------=_Part_19428_7605376.1200467442129 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? 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 ------=_Part_19428_7605376.1200467442129 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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?

On 16/01/2008, Joshua D. Drake <jd@commandprompt.com> 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 ------=_Part_19428_7605376.1200467442129--