Re: [GENERAL] Archive logging - Mailing list pgsql-general

From jerome doucerain
Subject Re: [GENERAL] Archive logging
Date
Msg-id 374A774B.27F96E0B@chu-nimes.fr
Whole thread Raw
In response to Re: [GENERAL] Archive logging  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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 by date:

Previous
From:
Date:
Subject: Undeliverable Message
Next
From: "Wheeler, Alfred"
Date:
Subject: unsubscribe pgsql-general