Re: Inherited an 18TB DB & need to backup

From: Suhail Bamzena <suhailsalem(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)jirotech(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Inherited an 18TB DB & need to backup
Date: 2020-05-18 05:49:50
Message-ID: CAA7EztXDENS_BtE2Yc-p1F20OvWH3B_C2nGLUSqjVKJ2npZmWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general pgsql-general

Thanks James... that is reassuring, will be working on it this week.

On Mon, 18 May 2020, 04:33 James Sewell, <james(dot)sewell(at)jirotech(dot)com> wrote:

>
>
> On Fri, 15 May 2020 at 17:09, Suhail Bamzena <suhailsalem(at)gmail(dot)com>
> wrote:
>
>> Hello All,
>> I have very recently inherited an 18 TB DB that is running version 9.2.
>> Apparently this database has never been backed up and I have been tasked to
>> set in a periodic backup routine (weekly full & daily incremental) and dump
>> it into a NAS. What is the best way to go about this? Did some reading and
>> hear that pgbackrest does a good job with such huge sizes. Your expert
>> advise is needed.
>>
>>
> Just chiming in for pgbackrest - we are backing up multiple databases in
> the 50TB - 150TB range across multiple customers and it works very well
> (and most importantly at that scale, very efficiently).
>
> I've found the team really responsive to issues / bugs / errors reported
> via GitHub when we hit them, which is always a bonus.
>
> James Sewell,
> *Chief Architect, Jirotech*
> Suite 46, Jones Bay Wharf, 26-32 Pirrama Road, Pyrmont NSW 2009
> *P *(+61) 2 8099 9000 <(+61)%202%208099%209000> *W* www.jirotech.com
> *F *(+61) 2 8099 9099 <(+61)%202%208099%209000>
>
>
> ------------------------------
> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.

In response to

Browse pgeu-general by date

  From Date Subject
Next Message Daniel Gustafsson 2020-07-10 21:14:47 PGConf.EU 2020 has been canceled
Previous Message Steve Litt 2020-05-18 01:55:09 Re: Inherited an 18TB DB & need to backup

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-05-18 06:32:39 Re: Hot and PITR backups in same server
Previous Message Ram Pratap Maurya 2020-05-18 05:06:17 pg_basebackup: child process exited with error 1