On Thu, 2025-03-20 at 17:22 +0530, Siraj G wrote:
> I have a DB with 1TB in size serving needs of one of our critical
> applications. I have a requirement to take export of the DB on a
> daily basis, but want to carry out this operation in read replica.
> The postgresql version is: 16.6
>
> What would be the RPO of such backup?
Depends on the speed of disk and network and on what an RPO is.
> What would be the impact on the READ REPLICA with a long running
> export operation?
Potentially severe.
You could look into storage technologies that allow you to take
a snapshot and clone it.
Yours,
Laurenz Albe