Search Postgresql Archives

Re: Postgres Point in time Recovery (PITR),

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/21/19 8:10 AM, Avinash Kumar wrote:
Hi,

On Mon, Oct 21, 2019 at 8:16 PM Alan Hodgson <ahodgson@xxxxxxxxxxxxxxx <mailto:ahodgson@xxxxxxxxxxxxxxx>> 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 ?

Well to me off-line means you have introduced an air gap between your on-line presence and your off-line backups. This would prevent an intruder from accessing the off-line backups.

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.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux