Re: Replication and PITR - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: Replication and PITR
Date
Msg-id 451378DE.9090307@netgroup.dk
Whole thread Raw
In response to Re: Replication and PITR  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Replication and PITR
List pgsql-general
Bill Moran wrote:
> - No reliability.  On slow days, WAL logs could take a long time to
>   rotate, so small but important transactions might not be replicated
>   for a long time.
>
So it is all right for backup but for replication it could end up laking
too much behind, and a fail over could be hours behind.

So PITR can be used, but one of the cons is the unpredictable delay of
data. I thought one of the ideas behind the PITR system was to get
rather reason backups of data ...

/BL


pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: ERROR: index "patient_pkey" is not a btree
Next
From: Bo Lorentsen
Date:
Subject: Re: Replication and PITR