Re: Export operation efficiency in read replica

On 20/03/2025 15:04, Adrian Klaver wrote:
> On 3/20/25 05:58, Siraj G wrote:
>> Hello Laurenz
>>
>> As per my understanding coming to a proper conclusion wrt RPO 
> 
> You still have not defined what RPO is.
> 

I guess the OP is talking about Recovery Point Objective, which is one 
of two important parameters WRT to disaster recovery. It's the maximum 
data loss you agree on with your backup solution. That mostly depends on 
the database context, something we can't tell. And according to how much 
you agree to lose (one minute of activity? one hour?), you then can 
choose between pg_dump or PITR backups.

But with a 1TB-database, I wouldn't dare using pg_dump. PITR backup is 
the only option.


-- 
Guillaume Lelarge
Consultant
https://dalibo.com