| From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
|---|---|
| To: | "'pgsql-admin(at)lists(dot)postgresql(dot)org'" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | "Ashish Chugh" <ashish(dot)chugh(at)lavainternational(dot)in> |
| Subject: | BG_Base Backup take 8 to 9Hrs |
| Date: | 2022-02-08 11:34:49 |
| Message-ID: | KL1PR0601MB443331C71F8E58484095FCB2F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ram Pratap Maurya | 2022-02-08 11:35:18 | Recall: BG_Base Backup take 8 to 9Hrs |
| Previous Message | Ram Pratap Maurya | 2022-02-08 11:33:27 | Recall: PostgreSQL Full Vacuum Taking 5 to 6 hrs. |