Depending on your storage subsystem, perhaps storage-level snapshots might be an option? They often seem to be the best choice for VLDBs.
From: Suhail Bamzena <suhailsalem@gmail.com> Sent: Friday, May 15, 2020 7:23 AM To: Christoph Berg <christoph.berg@credativ.de> Cc: Rory Campbell-Lange <rory@campbell-lange.net>; pgsql-general@lists.postgresql.org; pgeu-general@lists.postgresql.org Subject: EXTERNAL: Re: Inherited an 18TB DB & need to backup
Hi Christoph
Thats very high on my agenda.. but need to make sure i can backup this beast to start with..
Re: Rory Campbell-Lange > On 15/05/20, Suhail Bamzena (suhailsalem@gmail.com) wrote: > > Hello All, > > I have very recently inherited an 18 TB DB that is running version 9.2.
Push hard to get that upgraded to a supported version.