On Thursday, October 24, 2013 11:13:34 PM Jayadevan wrote: > Alan Hodgson wrote > > > That's basically what warm standby's do, isn't it? As long as they keep > > recovery open it should work. > > A warn standby will be almost in sync with the primary, right? So recovery > to point-in-time (like 10 AM this morning) won't be possible. We need a > base, but it shouldn't be so old that it takes hours to catchup- that was my > thought. As John mentioned, looking at the WAL/transaction numbers, time to > recover etc need to be looked at. > Well, yeah. The point was that you possibly could run it for a while to "catch up" without taking a new base backup if you desired. You should also keep copies of it for PITR. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
