Thread: 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