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