On Thu, Mar 20, 2025 at 7:52 AM Siraj G <tosiraj.g@xxxxxxxxx> wrote:
Hello Experts!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
Use PgBackRest from the streaming replica.
What would be the RPO of such backup?
Are you asking how long it takes to restore the backup back to the primary?
What would be the impact on the READ REPLICA with a long running export operation?
Why not use the standby server (aka "read replica") as the hot standby in case the Primary crashes hard?
Then pg_basebackup (or PgBackRest) to get the database back to the primary once it's back up.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
