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

From Jayadevan
Subject Re: PostgreSQL Point In Time Recovery
Date
Msg-id 1382681614651-5775874.post@n5.nabble.com
Whole thread Raw
In response to Re: PostgreSQL Point In Time Recovery  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: PostgreSQL Point In Time Recovery  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
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.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-Point-In-Time-Recovery-tp5775717p5775874.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Jayadevan
Date:
Subject: Re: PostgreSQL Point In Time Recovery
Next
From: Achilleas Mantzios
Date:
Subject: Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu