Replication and Switchover - Mailing list pgsql-admin

From Sam Stearns
Subject Replication and Switchover
Date
Msg-id CAN6TVj=01f6At2L4X7WM8g1c+18up8mSLB1GSKzJdJNAEUtaag@mail.gmail.com
Whole thread Raw
Responses Re: Replication and Switchover
List 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


pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: order of pg_dump command "create sequence"
Next
From: Антон Глушаков
Date:
Subject: Re: order of pg_dump command "create sequence"