Re: Backup of live database - Mailing list pgsql-admin

From Brian Modra
Subject Re: Backup of live database
Date
Msg-id 5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com
Whole thread Raw
In response to Re: Backup of live database  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Backup of live database  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Backup of live database
Next
From: Tom Lane
Date:
Subject: Re: Backup of live database