Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replication and Switchover

Replication and Switchover

From
Sam Stearns
Date:
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


Re: Replication and Switchover

From
Christoph Berg
Date:
Re: Sam Stearns
> 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?

Create a second database cluster, and move one of the databases into
that cluster.

"Move" is either dump-restore, or a full restore of the old cluster
and dropping the other database.

Christoph

Re: Replication and Switchover

From
Sam Stearns
Date:
Ah.  Got it.  Makes sense.  Thanks, Christoph!

Sam


On Fri, Jun 6, 2025 at 8:09 AM Christoph Berg <myon@debian.org> wrote:
Re: Sam Stearns > 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? Create a
ZjQcmQRYFpfptBannerStart
This Message Is From an Untrusted Sender
You have not previously corresponded with this sender.
 
ZjQcmQRYFpfptBannerEnd
Re: Sam Stearns
> 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?

Create a second database cluster, and move one of the databases into
that cluster.

"Move" is either dump-restore, or a full restore of the old cluster
and dropping the other database.

Christoph


--

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