Re: Replication and PITR

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Replication and PITR
Date: 2006-09-22 05:47:10
Message-ID: 451378DE.9090307@netgroup.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Casey Duncan 2006-09-22 05:48:00 Re: Backup Large Tables
Previous Message Shane Ambler 2006-09-22 05:24:50 Re: After Trigger