On 12/1/2017 12:44 PM, basti wrote:
Replication is no backup.
Its more like a RAID.

That mean tubles that are delete on master by a mistake there are also
delete on slave.

correct me if i'am wrong.

a wal archive plus occasional basebackups lets you restore to any point in time (PITR) covered since the oldest basebackup.

think of a base backup as a 'full' backup, and the wal logs in the archive as incrementals.    one such approach might be a weekly basebackup, where you keep the last 4 weeks, and keep all wal files since the start of oldest basebackup.   yes, this will take quite a bit of space


--
john r pierce, recycling bits in santa cruz


Reply via email to