Wed Jun 10 05:33:47 PDT 2009
- Previous message: [Slony1-general] Slony1-ctl 1.1.4 released
- Next message: [Slony1-general] Multi-slave replication question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony1-ctl 1.1.4 released
- Next message: [Slony1-general] Multi-slave replication question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list