Re: [GENERAL] Archive logging

From: jerome doucerain <jerome(dot)doucerain(at)chu-nimes(dot)fr>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Archive logging
Date: 1999-05-25 10:11:24
Message-ID: 374A774B.27F96E0B@chu-nimes.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-05-25 10:24:24 Re: [GENERAL] JDBC and insert - stack overflow
Previous Message MAILER-DAEMON 1999-05-25 08:23:56 Undeliverable Message