pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mladen Gogala <gogala.mladen@gmail.com>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
Date: Thu, 10 Feb 2022 11:45:25 -0500
Message-ID: <1b297f2c-aef1-084c-b10a-f36154fdd636@gmail.com> (raw)
In-Reply-To: <627d342b-6054-bb08-86d0-15c0a8e58887@sqlexec.com>
References: <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
	<91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
	<627d342b-6054-bb08-86d0-15c0a8e58887@sqlexec.com>

Please don't top-post.

On 2/10/22 09:31, MichaelDBA wrote:
> 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
>
I can wholeheartedly recommend Commvault backup suite. It can seamlessly 
utilize storage snapshot and has built in parallelism, deduplication and 
compression.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

view thread (11+ messages)  latest in thread

Message-ID: <1b297f2c-aef1-084c-b10a-f36154fdd636@gmail.com>
Permalink:  ../1b297f2c-aef1-084c-b10a-f36154fdd636@gmail.com/
Also on:    postgresql.org/message-id/1b297f2c-aef1-084c-b10a-f36154fdd636@gmail.com

 · 

reply
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, MichaelDBA@sqlexec.com, pgsql-admin@lists.postgresql.org
  Subject: Re: PG_Base Backup take 8 to 9Hrs
  In-Reply-To: <1b297f2c-aef1-084c-b10a-f36154fdd636@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