Re: Inherited an 18TB DB & need to backup - Mailing list pgsql-general

From Michael Nolan
Subject Re: Inherited an 18TB DB & need to backup
Date
Msg-id CAOzAquLS4AaKnwtg2U_o1bZRN0R7sbcYT7_-e0oLK-bGo1Pc+A@mail.gmail.com
Whole thread Raw
In response to Re: Inherited an 18TB DB & need to backup  ("Ravi Krishna" <srkrishna1@comcast.net>)
Responses Re: Inherited an 18TB DB & need to backup
List pgsql-general


On Fri, May 15, 2020 at 12:51 PM Ravi Krishna <srkrishna1@comcast.net> wrote:

Why should the backup land in S3, and not local somewhere?
Any good reason why one should pay for the additional storage and transfer costs?

Good question. The key point in my statement was "db of this size".

The problem with local backup is that space is not infinite. 

Another problem is storage devices fail.  S3 storage lakes _should_ be checking your data integrity on a regular basis and possibly maintaining copies of it iin multiple locations so you're not vulnerable to a site disaster.
--
Mike Nolan

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: schema agnostic functions in language sql
Next
From: Rob Sargent
Date:
Subject: Re: schema agnostic functions in language sql