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.
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 |
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 |