On Thu, Mar 20, 2025 at 7:52 AM Siraj G <tosira...@gmail.com> 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!
