Re: Backup of live database

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Backup of live database
Дата
Msg-id 478DAC1D.3010909@commandprompt.com
обсуждение исходный текст
Ответ на Backup of live database  ("Brian Modra" <epailty@googlemail.com>)
Ответы Re: Backup of live database  ("Brian Modra" <epailty@googlemail.com>)
Re: Backup of live database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Brian Modra"
Дата:
Сообщение: Backup of live database
Следующее
От: "Brian Modra"
Дата:
Сообщение: Re: Backup of live database