On Thu, Aug 12, 2010 at 4:18 PM, Simon Riggs <si...@2ndquadrant.com> wrote: > The safest approach is to > > 1. run pg_start_backup() on master, remember LSN > 2. copy backup_label from master to standby > 3. wait for starting LSN to be applied on standby
ISTM we should wait for the latest checkpoint redo location to reach the starting location which pg_start_backup() returns. > That ensures we don't run without full page writes during backup and > that we have an explicit consistency point to work from. Yeah, the current documented procedure might not work when full_page_writes is off on the master. This should be documented. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
