Postgres Pro
Downloads
Home   >   mailing lists

postgres large database backup - Mailing list pgsql-general

From Atul Kumar
Subject postgres large database backup
Date
Msg-id CA+ONtZ7CdiJ2X8x_8sPHR+tz-vv7mR1uoDzLia3fzWVZA9k0JQ@mail.gmail.com
Whole thread Raw
Responses Re: postgres large database backup  (Michael Loftis <mloftis@wgops.com>)
Re: postgres large database backup  (Christophe Pettus <xof@thebuild.com>)
Re: postgres large database backup  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Re: postgres large database backup  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-general
Tree view
Hi, 

I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way.

The scheduled backup will be used for PITR purposes.

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 and subsequently incremental backups in a faster way and restore it for PITR in a faster way when required.

What should be the exact approach for scheduling such backups so that it can be restored in a faster way ?



Regards.

pgsql-general by date:

Previous
From: Amitabh Kant
Date:
Subject: Re: Finding free time period on non-continous tstzrange field values
Next
From: Вадим Самохин
Date:
Subject: Re: postgresql 13.1: precision of spatial operations