From: Mladen Gogala <gogala.mladen@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
Date: Wed, 9 Feb 2022 19:42:48 -0500
Message-ID: <91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com> (raw)
In-Reply-To: <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
On 2/8/22 06:36, Ram Pratap Maurya wrote:
>
> 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.
>
Use storage snapshots, faster disks, faster Ethernet adapters and backup
software that supports deduplication. You are asking the list to
architect your backup solution. For that, some more information is
needed: what kind of machine are you using, what OS, how much memory,
what kind of storage is your cluster running on, what kind of storage
are you backing it up to, how is the backup storage connected (FC/AL,
Ethernet, local SATA drives), is there any degree of parallelism and
things of that nature. In the absence of that information, I can only
recommend attempting with the --run-faster switch to pg_basebackup. You
may also try using the Force.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
In-Reply-To: <91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox