From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
Date: Thu, 10 Feb 2022 09:31:28 -0500
Message-ID: <627d342b-6054-bb08-86d0-15c0a8e58887@sqlexec.com> (raw)
In-Reply-To: <91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
References: <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
Please use a third party backup solution that provides faster and more
flexible backup alternatives than the built in, pg_basebackup(), which
is not usefult for large databases.
pgbackrest (full, differential, and incremental)
barman (full and incremental)
Regards,
Michael Vitale
Mladen Gogala wrote on 2/9/2022 7:42 PM:
> 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: MichaelDBA@sqlexec.com, gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
In-Reply-To: <627d342b-6054-bb08-86d0-15c0a8e58887@sqlexec.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