Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uNYkh-004Sl4-5p
	for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jun 2025 15:13:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1uNYkf-00CEQI-A4
	for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jun 2025 15:13:01 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <cb@df7cb.de>)
	id 1uNYhH-00C6Yw-D0
	for pgsql-admin@lists.postgresql.org; Fri, 06 Jun 2025 15:09:32 +0000
Received: from mout-p-102.mailbox.org ([80.241.56.152])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cb@df7cb.de>)
	id 1uNYhF-000b2q-2N
	for pgsql-admin@lists.postgresql.org;
	Fri, 06 Jun 2025 15:09:31 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org
 [IPv6:2001:67c:2050:b231:465::1])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest
 SHA256)
	(No client certificate requested)
	by mout-p-102.mailbox.org (Postfix) with ESMTPS id 4bDPqQ1wnVz9tbS;
	Fri,  6 Jun 2025 17:09:22 +0200 (CEST)
Date: Fri, 6 Jun 2025 17:09:21 +0200
From: Christoph Berg <myon@debian.org>
To: Sam Stearns <sam.stearns@dat.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	Peter Garza <peter.garza@dat.com>, Henry Ashu <henry.ashu@dat.com>
Subject: Re: Replication and Switchover
Message-ID: <aEMEoSPkw8HqEiPR@msg.df7cb.de>
References: 
 <CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com>
X-Rspamd-Queue-Id: 4bDPqQ1wnVz9tbS
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/aEMEoSPkw8HqEiPR%40msg.df7cb.de>
Precedence: bulk

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