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

From Joshua D. Drake
Subject Re: Backup of live database
Date
Msg-id 478DAC1D.3010909@commandprompt.com
Whole thread Raw
In response to Backup of live database  ("Brian Modra" <epailty@googlemail.com>)
Responses Re: Backup of live database  ("Brian Modra" <epailty@googlemail.com>)
Re: Backup of live database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Brian Modra"
Date:
Subject: Backup of live database
Next
From: "Brian Modra"
Date:
Subject: Re: Backup of live database