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

From Christophe Pettus
Subject Re: Inherited an 18TB DB & need to backup
Date
Msg-id D839F547-FF49-445A-A856-D94AB4967A19@thebuild.com
Whole thread Raw
In response to Re: Inherited an 18TB DB & need to backup  (Scottix <scottix@gmail.com>)
List pgsql-general

> On May 15, 2020, at 12:01, Scottix <scottix@gmail.com> wrote:
>
> Also when you get in the multi TB data storage the bill gets a little harder to digest in S3.

Indeed.  Right now, just buying off of Amazon, a 12TB Seagate IronWolf drive is $0.03/GB.  S3 infrequent access is
$0.0125/GB/month,so the drive pays for itself (storage only) in 2.4 months.  Even with an annualized failure rate of
1.4%(per Backblaze), and with the required host, rack, etc., etc., it be significantly more economical to run your own
backupserver.  If you regularly do restores off of the backups (for example, to prime staging environments or developer
systems),the outbound transfer can add up fast, too. 
--
-- Christophe Pettus
   xof@thebuild.com




pgsql-general by date:

Previous
From: Andy Cooper
Date:
Subject: Unexplained Access Exclusive Locks on Follower from PID7
Next
From: Ron
Date:
Subject: Re: Inherited an 18TB DB & need to backup