Re: Backup_Long Running

Thanks for your update. Can you have any link or document to configure L0 &
L1 backup using pgbackrest tool. Also share the pgbackrest installation
method.

On Wed, Apr 24, 2024 at 2:50 PM Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

>
> On Wed, Apr 24, 2024, 12:33 PM jaya kumar <kumardba27(at)gmail(dot)com> wrote:
>
>> Hi Team,
>>
>>
>>
>> Production database Backup is running very long hours. Any option to
>> reduce backup time? Kindly advise me.
>>
>>
>>
>> DB size: 793 GB
>>
>>
>>
>> We are taking pg_basebackup backup.
>>
>>
> do you see network saturation, io saturation ?
> generally faster hardware i.e striped and or nvme disks along with a
> robust network link and capacity should help get the backup done quickly.
> where are you taking the backup from? is the server busy doing other work
> or it is a dedicated machine for backups ?
> basically monitor for resource saturation, if all looks good, we could
> take basebackup of a 10tb db in 8 hours, and in another case on a slow
> remote storage, backup of 2tb took 1 day.
>
> now, pgbackrest can speedup backup processes by spawning more workers for
> archiving and stuff. we have taken backup on nvme disks striped of 28tb in
> 3 hours, bare metals servers with powerful cpu.
>
> so , it's hardware .... else switch to pgbackrest which can take
> incremental/differential/full backups.
> there are other tools too, I used only these two.
>
>>
>>

--
Thanks & Regards,
Jayakumar.S
+91-9840864439.