Bill Moran wrote:
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.- 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 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
