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
