On Feb 13, 2013 10:29 PM, "Heikki Linnakangas" <hlinnakan...@vmware.com> wrote: > Hmm, I just realized a little problem with that approach. If you take a base backup using an atomic filesystem backup from a running server, and start archive recovery from that, that's essentially the same thing as Kyotaro's test case.
Coincidentally I was wondering about the same thing when I was reviewing our slave provisioning procedures. There didn't seem to be any communication channel from pg_stop_backup for the slave to know when it was safe to allow connections. Maybe there should be some mechanism akin to backup label to communicate the minimum recovery point? When the min recovery point file exists the value inside it is used, when the recovery point is reached the file is removed. pg_basebackup would just append the file to the archive. Custom backup procedures could also use it to communicate the necessary WAL location. -- Ants Aasma