Postgres Pro
Downloads
Home   >   mailing lists

BG_Base Backup take 8 to 9Hrs - Mailing list pgsql-admin

From Ram Pratap Maurya
Subject BG_Base Backup take 8 to 9Hrs
Date
Msg-id KL1PR0601MB443331C71F8E58484095FCB2F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com
Whole thread Raw
List pgsql-admin
Tree view

Hi Team,

 

We are using Postgres -11 version and current PG DB size is 450 GB .

Archive log enable in Database and we are running Full PG_Base backup and it will take 8 to 9 Hrs to complete the backup ,

Please suggest  how to reduce the full DB backup time.

 

OS Version : RHEL6

DB size -450 GB

Postgresql Version -11

 

 

 

 

Regards,

Ram Pratap.

 

pgsql-admin by date:

Previous
From: Ram Pratap Maurya
Date:
Subject: Recall: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Next
From: Ram Pratap Maurya
Date:
Subject: Recall: BG_Base Backup take 8 to 9Hrs