postgres large database backup

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: postgres large database backup
Date: 2022-11-30 15:40:23
Message-ID: CA+ONtZ7CdiJ2X8x_8sPHR+tz-vv7mR1uoDzLia3fzWVZA9k0JQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Вадим Самохин 2022-11-30 15:48:31 Re: postgresql 13.1: precision of spatial operations
Previous Message Amitabh Kant 2022-11-30 14:13:17 Re: Finding free time period on non-continous tstzrange field values