Request a Demo
Home   >   mailing lists

Postgres DB backup is taking too much time - Mailing list pgsql-performance

From masheed ullah
Subject Postgres DB backup is taking too much time
Date
Msg-id CAHr8x_sQww+XNAFoHkyjYKJYq3CVcQLxJL0yaY3GHNzO3YV+bw@mail.gmail.com
Whole thread
Responses Re: Postgres DB backup is taking too much time
Re: Postgres DB backup is taking too much time
Re: Postgres DB backup is taking too much time
List pgsql-performance
Tree view
Hi,

We have a database of 20TB, and it's taking almost 24 hours to complete. While full restore takes 28 hours. Although we have HA enabled with primary and multiple replica's.
So we need a solution/tool to reduce the RTO, incase of disk failure/ Human error for data/tables deletion.

We are using Barman for backup.
My question is "Are there any tools like ZDLRA appliances for Oracle" to reduce the RTO to less than 10 hours".

Best Regards,
Khattak


pgsql-performance by date:

Previous
From: Viktor Holmberg
Date:
Subject: Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE
Next
From: manish yadav
Date:
Subject: Re: Postgres DB backup is taking too much time