| From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
|---|---|
| To: | Christoph Berg <myon(at)debian(dot)org> |
| 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:17:37 |
| Message-ID: | CAN6TVj=bfz7Yq+SfzzFEo_7YhLExv=aRfFdkm0ZeAkt9RFg-Ow@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Ah. Got it. Makes sense. Thanks, Christoph!
Sam
On Fri, Jun 6, 2025 at 8:09 AM Christoph Berg <myon(at)debian(dot)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
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-06-06 18:48:45 | Re: order of pg_dump command "create sequence" |
| Previous Message | Christoph Berg | 2025-06-06 15:09:21 | Re: Replication and Switchover |