Postgres Pro
Downloads
Home   >   mailing lists

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

From Suhail Bamzena
Subject Inherited an 18TB DB & need to backup
Date
Msg-id CAA7EztXsnSSMv7u85Hx1mNYZK23moFcQ5q5aZ1fUBT76NCB1UQ@mail.gmail.com
Whole thread Raw
Responses Re: Inherited an 18TB DB & need to backup  (Rory Campbell-Lange <rory@campbell-lange.net>)
Re: Inherited an 18TB DB & need to backup  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
Tree view
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. 

--
Cheers,

Suhail 
Cell#  +97150 8194870

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Check what has been done for a uncommitted prepared transaction
Next
From: PALAYRET Jacques
Date:
Subject: Circles with circle() vs ST_Buffer() Equality equalities