public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sam Stearns <[email protected]>
To: Pgsql-admin <[email protected]>
Cc: Peter Garza <[email protected]>
Cc: Henry Ashu <[email protected]>
Subject: Replication and Switchover
Date: Fri, 6 Jun 2025 07:45:27 -0700
Message-ID: <CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com> (raw)

Howdy,

We have 2 databases running out of a single database cluster.  We would
like to set up replication from the existing host to a new host and then
switchover to that new host.  One of the databases is ready to switchover
now while the other database is going to take a bit more time to be ready
for the switchover.

We would like to switchover the database that is ready now so we can start
performing load testing against it.  Is it possible to switchover one
database in a cluster while not switching over the other?

Thanks,

Sam

-- 

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Replication and Switchover
  In-Reply-To: <CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox