Re: Postgres Point in time Recovery (PITR),

Поиск
Список
Период
Сортировка
От Avinash Kumar
Тема Re: Postgres Point in time Recovery (PITR),
Дата
Msg-id CAN0TujdNZ3cA=OkmB89=YZWidgj28C95k-_6zmrPzzHo-wpE9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres Point in time Recovery (PITR),  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Ответы Re: Postgres Point in time Recovery (PITR),  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Postgres Point in time Recovery (PITR),  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Список pgsql-general
Hi,

On Mon, Oct 21, 2019 at 8:16 PM Alan Hodgson <ahodgson@lists.simkin.ca> wrote:
On Mon, 2019-10-21 at 16:40 +0530, Avinash Kumar wrote:

We need to ensure that we have safe backup locations, for example, push them to AWS S3 and forget about redundancy. 
Why do you think only Offline Backups are reliable today ? 


There have been examples of hackers gaining control of an organization's servers or cloud accounts and not only destroying their online systems but also methodically deleting all their backups. 

There are fewer things that can go catastrophically wrong if one has actual offline backups. You have to be a lot more careful about protecting anything attached to the Internet.
I do not agree with this. If a hacker is gaining control of your organizational servers to destroy your Online backups, can't he destroy the offline backups and your database ?  
This is not a right justification to encouraging Offline Backups over Online Backups. 
If you are worried about storing your online backups through internet on cloud (i do not agree as you can still secure your data on cloud), store it in on a server in your Organizational network and do not push them through internet.
Taking Offline Backups is not the only right way to ensure Reliable Backups. 
We are way ahead of the days where you need to face downtime to take backups. 
Online Backups are reliable in PostgreSQL. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: jsonb_set() strictness considered harmful to data
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgres Point in time Recovery (PITR),