Postgres Pro
Downloads
Home   >   mailing lists

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

From Jayadevan
Subject Re: PostgreSQL Point In Time Recovery
Date
Msg-id 1382768082809-5775997.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  (Gregory Haase <haaseg@onefreevoice.com>)
List pgsql-general
Tree view 
Alan Hodgson wrote
> 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.

Something like this -
delayed replication
<http://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html>   might
help. I could say lag by 12 hours, or 10000 transactions...



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

pgsql-general by date:

Previous
From: Patrick Dung
Date:
Subject: Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu
Next
From: Gregory Haase
Date:
Subject: Re: PostgreSQL Point In Time Recovery