Re: PG_Base Backup take 8 to 9Hrs

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