| From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Cc: | Peter Garza <peter(dot)garza(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com> |
| Subject: | Replication and Switchover |
| Date: | 2025-06-06 14:45:27 |
| Message-ID: | CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Антон Глушаков | 2025-06-06 15:07:22 | Re: order of pg_dump command "create sequence" |
| Previous Message | Keith | 2025-06-06 14:18:40 | Re: order of pg_dump command "create sequence" |