Re: pg data backup from vps
От | John R Pierce |
---|---|
Тема | Re: pg data backup from vps |
Дата | |
Msg-id | 0913501f-3db8-b175-c368-12797b2e53aa@hogranch.com обсуждение исходный текст |
Ответ на | Re: pg data backup from vps (basti <mailinglist@unix-solution.de>) |
Ответы |
Re: pg data backup from vps
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: