-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 g h a écrit : > I am trying to set up SlonyI to replicated a master DB to two slaves and I am > encountering an error when I try to set up the routes. I have the following > Slonik script: > > cluster name = mycluster; > node 1 admin conninfo = 'dbname=mydb host=master user=postgres'; > node 2 admin conninfo = 'dbname=mydb host=slave1 user=postgres'; > node 3 admin conninfo = 'dbname=mydb host=slave2 user=postgres'; > > init cluster ( id=1, comment='abc' ); > create set ( id=1, origin=1, comment='abcd' ); > set add table ( set id=1, origin=1, id=1, fully qualified > name='myschema.mytable', comment='a Table' ); > > store node ( id=2, comment='slave1', event node=1 ); > store path ( server=1, client=2, conninfo='dbname=mydb host=master > user=postgres' ); > store listen ( origin=1, provider=1, receiver=2 ); > > store node ( id=3, comment='slave2', event node=1 ); > store path ( server=1, client=3, conninfo='dbname=mydb host=master > user=postgres' ); > store listen ( origin=1, provider=1, receiver=3 ); > > > However, it is failing on the second call to store node as the cluster schema > was already created in the first call to store node. I am curious as to why > the first call is touching my slave2 database. Is this the proper way to have > two-slave replication? > > Error message is: "Error: namespace "_mycluster" already exists in database > of node 3". > > Thanks, > g h
Hi, I don't know why Slony should have created anything on node 3, despite the fact you already tried to create node 3 in the paste. Are you working with fresh installed schemas ? Which version of Slony are you using ? (BTW, store listen is no more needed with newer version of slony (at least 1.2 and 2.0).) Regards, - -- Stéphane Schildknecht PostgreSQLFr - http://www.postgresql.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFKL7CyA+REPKWGI0ERAt0KAKCbRXU7suE+obdYqHCRAwcPsnz6ZQCfYPUq r1TZuc0ZiSC/MRo//iu5NJQ= =NDci -----END PGP SIGNATURE----- _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
