Re: [GENERAL] Archive logging

Поиск
Список
Период
Сортировка
От jerome doucerain
Тема Re: [GENERAL] Archive logging
Дата
Msg-id 374A774B.27F96E0B@chu-nimes.fr
обсуждение исходный текст
Ответ на Re: [GENERAL] Archive logging  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-general
You may start postmaster with -d2 option. This will trace your SQL requests.
If you redirect output to a flat file, you will get near a redo log file. The
only thing you have to do is to filter this redo log file to keep only
insert, update, delete SQL statements. So combined with backup, you are able
to rebuild your database until the last instant :
first step you restore from last backup
second step apply updates kept in redo log file
The matter is to synchronize "end of backup" and "begin of redo log". You may
stop postmaster, do a cold backup, and then restart postmaster on a new redo
log.
Jerome


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

Предыдущее
От:
Дата:
Сообщение: Undeliverable Message
Следующее
От: "Wheeler, Alfred"
Дата:
Сообщение: unsubscribe pgsql-general