Questions regarding generating the WAL File.
If I put a postgres 8.2 in an archive mode, it starts logging the WAL
files. The db starts the WAL File from 000010000001.gz and continually
increments the number.
Is there a control on 8.2 where I can indicate the number of the WAL
file to start from?
On the reverse, can I indicate to a db in recovery mode to start
consuming WAL Files from a particular number?
Regards
Dhaval Shah
On Tuesday 13 March 2007 14:23, "Dhaval Shah" <dhaval.shah.m@gmail.com>
wrote:
On the reverse, can I indicate to a db in recovery mode to start
consuming WAL Files from a particular number?
The recovery process is documented at
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-PITR-RECOVERY
The short answer, I believe, is no, but you can tell it to stop
recovering at a certain point in time.
--
"When Government fears the people, it's liberty. When people fear the
Government, it's tyranny." -- Benjamin Franklin