Charmed PostgreSQL How-to - Async: Switchover

Switchover of Async replication

WARNING: it is an internal article. Do NOT use it in production! Contact Canonical Data Platform team if you are interested in the topic.

Pre-requisits

Please make sure both the Rome and Lisbon Clusters are deployed using the Async Deployment manual!

Switchover

Assuming Rome is currently the Primary cluster and you want to promote Lisbon to be the new primary cluster
(Rome will be converted to Standby cluster):

juju run -m lisbon db2/leader promote-cluster force-promotion=true