Hi,
I am trying to replicate two databases in a simple 1 master, 1 slave
configuration. I was successful with one database but unsuccessful with 2. I
was wondering if anyone could point out my mistake in my slonik script trying
to replicate 2 databases. I have read that a simple way to go around is to
have the tables in the same schema but I would like to keep the databases
separate. Here is my slonik script:
cluster name = slony_dbOne;node 1 admin conninfo='host=192.168.112.4 dbname=db
user=postgres password=postgres';node 2 admin conninfo='host=192.168.112.5
dbname=db user=postgres password=postgres';
init cluster (id=1,comment='node 1 dbOne');
#CREATE SETcreate set (id = 1, origin = 1, comment = 'tables');
#SET ADD TABLEset add table (set id=1, origin=1, id=1, fully qualified name =
'schema1.table2',comment='');set add table (set id=1, origin=1, id=2, fully
qualified name = 'schema1.table2',comment='');
#STORE NODEstore node ( id = 2, comment = 'node 2 dbOne' );
#STORE PATHstore path ( server = 1, client = 2, conninfo = 'dbname=db
host=192.168.112.4 user=postgres password=postgres');store path ( server = 2,
client = 1, conninfo = 'dbname=db host=192.168.112.5 user=postgres
password=postgres');
#STORE LISTENstore listen ( origin = 1, provider = 1, receiver = 2 );store
listen ( origin = 2, provider = 2, receiver = 1 );
cluster name = slony_dbTwo;
node 3 admin conninfo='host=192.168.112.4 dbname=dbTwo user=postgres
password=postgres';node 4 admin conninfo='host=192.168.112.5 dbname=dbTwo
user=postgres password=postgres';
init cluster (id=3,comment='node 1 dbTwo');
#CREATE SETcreate set (id = 2, origin = 3, comment = 'tables');
#SET ADD TABLEset add sequence (set id=2, origin=3, id=1, fully qualified name
= 'schema1.table1', comment='');
#STORE NODEstore node ( id = 4, comment = 'node 2 dbTwo' );
#STORE PATHstore path ( server = 3, client = 4, conninfo = 'dbname=dbTwo
host=192.168.112.4 user=postgres password=postgres');store path ( server = 4,
client = 3, conninfo = 'dbname=dbTwo host=192.168.112.5 user=postgres
password=postgres');
#STORE LISTENstore listen ( origin = 3, provider = 3, receiver = 4 );store
listen ( origin = 4, provider = 4, receiver = 3 );
_________________________________________________________________
Internet explorer 8 lets you browse the web faster.
http://go.microsoft.com/?linkid=9655582_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
