On Tue, Nov 27, 2012 at 6:59 AM, Kevin Grittner <kgrittn@xxxxxxxx> wrote: > wd wrote: > >> the time is between backup start and stop. > > That is the problem -- until the point where pg_stop_backup() was > run PostgreSQL can't be sure of having a consistent database. It is > waiting from enough WAL to get it there. My practice is always to > keep the last two base backups and all WAL from the start of the > earlier one to current. If I want to recover to a point in time > which was during a backup, I use the previous base backup, which is > complete and usable. > > It does seem that there is an opportunity here to make it more > clear what is happening. It seems like the code is already there to throw an error, it is just that hot_standby=on somehow suppresses it during this window. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
