Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication and Switchover - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Replication and Switchover
Date
Msg-id CAN6TVj=bfz7Yq+SfzzFEo_7YhLExv=aRfFdkm0ZeAkt9RFg-Ow@mail.gmail.com
Whole thread Raw
In response to Re: Replication and Switchover  (Christoph Berg <myon@debian.org>)
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Christoph Berg
Date:
Subject: Re: Replication and Switchover
Next
From: Tom Lane
Date:
Subject: Re: order of pg_dump command "create sequence"