Hi,

 

 

I am using slony-2.0.4 with PostgreSQL 8.4 in Windows Xp. I have two
machines -A and B , where A acts as master and B acts as slave. 

The script is like,

cluster name = sql_cluster;

node 1 admin conninfo = 'dbname=postgres host=10.1.28.69 port=5432
user=postgres password=sa123!';

node 2 admin conninfo = 'dbname=postgres host=10.1.28.33 port=5432
user=postgres password=sa123!';

 

init cluster (id = 1, comment = 'Node 1');

 

create set (id = 1, origin = 1, comment = 'Test table');

set add table (set id =1, origin = 1, id = 2,full qualified name =
'public.test', comment = 'Table Test1', Key='test_pkey');

 

store node (id = 2, comment = 'Node 2', event node=1);

store path (server = 1, client = 2,conninfo = 'dbname=postgres
host=10.1.28.69 user=postgres password=sa123!');

store path (server = 2, client = 1, conninfo = 'dbname=postgres
host=10.1.28.33 port=5432 user=postgres password=sa123!');

 

store listen (origin = 1, provider = 1, receiver = 2);

store listen (origin = 2, provider = 2, receiver = 1);

 

When the machine A is failed the slave machine B is promoted to master .
The promotion script is like,

 

cluster name = sql_cluster;

node 1 admin conninfo = 'dbname=postgres host=10.20.30.2 port=5432
user=postgres';

node 2 admin conninfo = 'dbname=postgres host=10.20.30.3 port=5432
user=postgres';

failover (id = 1, backup node = 2);

drop node(id = 1, event node = 2);

 

 

My requirement is that, 

I have to reconnect the Machine A to the replication set, and  then make
the machine A master and Machine B slave. Please help me to create the
script for this.

 

[ when the machine A is connected again, the cluster is already present
in the 'master' database.  When I tried to start the slony service in
Machine A the cluster get removed. How can I subscribe Machine A]

 

 

 

 

 

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101015/828da654/attachment.htm