Hi,
I am using Slony-I for database replication.
When the master machine is failed, the slave machine is promoted to master. The script used for this is as below,
cluster name = sql_cluster;
node 1 admin conninfo = 'dbname=postgres host=10.1.20.55 port=5432 user=postgres';
node 2 admin conninfo = 'dbname=postgres host=10.1.20.56 port=5432 user=postgres';
failover (id = 1, backup node = 2);
drop node(id = 1, event node = 2);
It works fine. My requirement is that when the Node 1 is again connected, the Node 2(current master) should be demoted to Slave and the Promote Node 1 to Master. Please help to create the script file for this.
Thanks & Regards,
Vishnu S
***** Confidentiality Statement/Disclaimer *****
This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.