Re: pg data backup from vps

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