Re: Replication and Switchover

From: Christoph Berg <myon(at)debian(dot)org>
To: Sam Stearns <sam(dot)stearns(at)dat(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Peter Garza <peter(dot)garza(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com>
Subject: Re: Replication and Switchover
Date: 2025-06-06 15:09:21
Message-ID: aEMEoSPkw8HqEiPR@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Stearns 2025-06-06 15:17:37 Re: Replication and Switchover
Previous Message Антон Глушаков 2025-06-06 15:09:04 Re: order of pg_dump command "create sequence"