Re: Backup of live database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backup of live database
Дата
Msg-id 29616.1200525990@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Backup of live database  (Tom Davies <tgdavies@gmail.com>)
Список pgsql-admin
Tom Davies <tgdavies@gmail.com> writes:
> On 17/01/2008, at 4:42 AM, Tom Arthurs wrote:
>> The important thing is to start archiving the WAL files *prior* to
>> the first OS backup, or you will end up with an unusable data base.

> Why does the recovery need WAL files from before the backup?

It doesn't, but there's no reasonable way to start both processes at
exactly the same instant, so the standard advice is to start archiving
first.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange client encoding issue
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Backup of live database