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
