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

From Ron
Subject Re: Inherited an 18TB DB & need to backup
Date
Msg-id cd2b1610-5656-7a43-14eb-48386fb50416@gmail.com
Whole thread Raw
In response to Re: Inherited an 18TB DB & need to backup  (Michael Nolan <htfoot@gmail.com>)
Responses Re: Inherited an 18TB DB & need to backup
List pgsql-general
On 5/15/20 6:01 PM, Michael Nolan wrote:

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.

Tape FTW!!

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Suhail Bamzena
Date:
Subject: Re: Inherited an 18TB DB & need to backup
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Enforcing uniqueness on [real estate/postal] addresses