Re: Inherited an 18TB DB & need to backup

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: Ravi Krishna <srkrishna1(at)comcast(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, pgeu-general(at)lists(dot)postgresql(dot)org
Subject: Re: Inherited an 18TB DB & need to backup
Date: 2020-05-15 23:01:43
Message-ID: CAOzAquLS4AaKnwtg2U_o1bZRN0R7sbcYT7_-e0oLK-bGo1Pc+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general pgsql-general

On Fri, May 15, 2020 at 12:51 PM Ravi Krishna <srkrishna1(at)comcast(dot)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

In response to

Responses

Browse pgeu-general by date

  From Date Subject
Next Message Suhail Bamzena 2020-05-16 00:20:00 Re: Inherited an 18TB DB & need to backup
Previous Message Ron 2020-05-15 22:25:55 Re: Inherited an 18TB DB & need to backup

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2020-05-15 23:07:07 Re: schema agnostic functions in language sql
Previous Message Adrian Klaver 2020-05-15 22:58:05 Re: schema agnostic functions in language sql