Re: Postgres Point in time Recovery (PITR), - Mailing list pgsql-general

From Avinash Kumar
Subject Re: Postgres Point in time Recovery (PITR),
Date
Msg-id CAN0TujdNZ3cA=OkmB89=YZWidgj28C95k-_6zmrPzzHo-wpE9g@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Point in time Recovery (PITR),  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Responses Re: Postgres Point in time Recovery (PITR),
Re: Postgres Point in time Recovery (PITR),
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: jsonb_set() strictness considered harmful to data
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres Point in time Recovery (PITR),