Re: PostgreSQL Point In Time Recovery - Mailing list pgsql-general

From Alan Hodgson
Subject Re: PostgreSQL Point In Time Recovery
Date
Msg-id 1406303.vzTl06xVfo@skynet.simkin.ca
Whole thread Raw
In response to Re: PostgreSQL Point In Time Recovery  (Jayadevan <maymala.jayadevan@gmail.com>)
Responses Re: PostgreSQL Point In Time Recovery
List pgsql-general
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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Recheck conditions" on indexes
Next
From: Robert James
Date:
Subject: Re: Count of records in a row