Re: Postgres Point in time Recovery (PITR),

Hi,

On Mon, Oct 21, 2019 at 8:16 PM Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)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.