Automate the switchover of a cluster with replication
If the results of the tests with logical replication are positive the next step is to automate in ansible these steps for the traffic switchover and promotion of the database using logical replication.
Please create an ansible playbook to automate the switchover of logical replication.
Acceptance criteria:
-
Create the playbook to setup logical replication