Re: Inherited an 18TB DB & need to backup

From: Suhail Bamzena <suhailsalem(at)gmail(dot)com>
To: Rory Campbell-Lange <rory(at)campbell-lange(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 13:38:13
Message-ID: CAA7EztUhaORESDX-yiWYJhGCqFXieJ6TgZ7NeDZ0nFwXWc_Kgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general pgsql-general

Yeah Rory want to pull one asap..hopefully by COB tonight..

On Fri, 15 May 2020, 17:35 Rory Campbell-Lange, <rory(at)campbell-lange(dot)net>
wrote:

> On 15/05/20, Suhail Bamzena (suhailsalem(at)gmail(dot)com) wrote:
> > Thanks Rory, the machine has the capacity to pull through pg_dumps but
> like
> > u rightly mentioned incremental backups mean that we will need to work
> with
> > the wal's.. 18TB is what is the scary part and with compression I dont
> see
> > it being less than 2TB a day...
>
> I suggest you try one immediately, assuming you can dump it somewhere
> and the machine has the resources. Then you will at least have a backup
> and a sense of what is possible. (Which will help inform your upgrade
> strategy too.)
>
> Rory
>
>

In response to

Browse pgeu-general by date

  From Date Subject
Next Message Ravi Krishna 2020-05-15 13:49:03 Re: Inherited an 18TB DB & need to backup
Previous Message Rory Campbell-Lange 2020-05-15 13:35:34 Re: Inherited an 18TB DB & need to backup

Browse pgsql-general by date

  From Date Subject
Next Message Gavan Schneider 2020-05-15 13:40:31 Re: PG12.2 Configure cannot enalble SSL
Previous Message Rory Campbell-Lange 2020-05-15 13:35:34 Re: Inherited an 18TB DB & need to backup