Re: postgres large database backup - Mailing list pgsql-general

From Christophe Pettus
Subject Re: postgres large database backup
Date
Msg-id 75EDB99D-C34A-426E-AD6A-A904E2BE96A5@thebuild.com
Whole thread Raw
In response to postgres large database backup  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general

> On Nov 30, 2022, at 07:40, Atul Kumar <akumar14871@gmail.com> wrote:
> So please let me know how I should do it in a quicker backup for my 10TB database ? Is there any tool to take backups
andsubsequently incremental backups in a faster way and restore it for PITR in a faster way when required. 

For an initial backup, you'll need to copy 10TB to another medium; there's no getting around that.  pgBackRest supports
incrementaland differential backups, which are especially useful if there are tables that are largely for archival
purposesand do not get frequently modified: 

    https://pgbackrest.org


pgsql-general by date:

Previous
From: Michael Loftis
Date:
Subject: Re: postgres large database backup
Next
From: Vijaykumar Jain
Date:
Subject: Re: postgres large database backup