public inbox for [email protected]help / color / mirror / Atom feed
Export operation efficiency in read replica 3+ messages / 3 participants [nested] [flat]
* Export operation efficiency in read replica @ 2025-03-20 11:52 Siraj G <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Siraj G @ 2025-03-20 11:52 UTC (permalink / raw) To: [email protected] 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 What would be the RPO of such backup? What would be the impact on the READ REPLICA with a long running export operation? Thank you! Siraj ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Export operation efficiency in read replica @ 2025-03-20 11:59 Laurenz Albe <[email protected]> parent: Siraj G <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Laurenz Albe @ 2025-03-20 11:59 UTC (permalink / raw) To: Siraj G <[email protected]>; [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Export operation efficiency in read replica @ 2025-03-20 14:17 Ron Johnson <[email protected]> parent: Siraj G <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Ron Johnson @ 2025-03-20 14:17 UTC (permalink / raw) To: pgsql-general On Thu, Mar 20, 2025 at 7:52 AM Siraj G <[email protected]> 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! ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-03-20 14:17 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-20 11:52 Export operation efficiency in read replica Siraj G <[email protected]> 2025-03-20 11:59 ` Laurenz Albe <[email protected]> 2025-03-20 14:17 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox