Hi,
I am trying to replicate two databases in a simple 1 master, 1 slave config=
uration.  I was successful with one database but unsuccessful with 2.  I wa=
s 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 t=
o have the tables in the same schema but I would like to keep the databases=
 separate.  Here is my slonik script:
cluster name =3D slony_dbOne;node 1 admin conninfo=3D'host=3D192.168.112.4 =
dbname=3Ddb user=3Dpostgres password=3Dpostgres';node 2 admin conninfo=3D'h=
ost=3D192.168.112.5 dbname=3Ddb user=3Dpostgres password=3Dpostgres';
init cluster (id=3D1,comment=3D'node 1 dbOne');
#CREATE SETcreate set (id =3D 1, origin =3D 1, comment =3D 'tables');
#SET ADD TABLEset add table (set id=3D1, origin=3D1, id=3D1, fully qualifie=
d name =3D 'schema1.table2',comment=3D'');set add table (set id=3D1, origin=
=3D1, id=3D2, fully qualified name =3D 'schema1.table2',comment=3D'');
#STORE NODEstore node ( id =3D 2, comment =3D 'node 2 dbOne' );
#STORE PATHstore path ( server =3D 1, client =3D 2,	conninfo =3D 'dbname=3D=
db host=3D192.168.112.4 user=3Dpostgres password=3Dpostgres');store path ( =
server =3D 2, client =3D 1,	conninfo =3D 'dbname=3Ddb host=3D192.168.112.5 =
user=3Dpostgres password=3Dpostgres');
#STORE LISTENstore listen ( origin =3D 1, provider =3D 1, receiver =3D 2 );=
store listen ( origin =3D 2, provider =3D 2, receiver =3D 1 );
cluster name =3D slony_dbTwo;
node 3 admin conninfo=3D'host=3D192.168.112.4 dbname=3DdbTwo user=3Dpostgre=
s password=3Dpostgres';node 4 admin conninfo=3D'host=3D192.168.112.5 dbname=
=3DdbTwo user=3Dpostgres password=3Dpostgres';
init cluster (id=3D3,comment=3D'node 1 dbTwo');
#CREATE SETcreate set (id =3D 2, origin =3D 3, comment =3D 'tables');
#SET ADD TABLEset add sequence (set id=3D2, origin=3D3, id=3D1, fully quali=
fied name =3D 'schema1.table1', comment=3D'');
#STORE NODEstore node ( id =3D 4, comment =3D 'node 2 dbTwo' );
#STORE PATHstore path ( server =3D 3, client =3D 4, conninfo =3D 'dbname=3D=
dbTwo host=3D192.168.112.4 user=3Dpostgres password=3Dpostgres');store path=
 ( server =3D 4, client =3D 3, conninfo =3D 'dbname=3DdbTwo host=3D192.168.=
112.5 user=3Dpostgres password=3Dpostgres');
#STORE LISTENstore listen ( origin =3D 3, provider =3D 3, receiver =3D 4 );=
store listen ( origin =3D 4, provider =3D 4, receiver =3D 3 );
 		 	   		  =

_________________________________________________________________
Internet explorer 8 lets you browse the web faster.
http://go.microsoft.com/?linkid=3D9655582
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090930/=
f6cda629/attachment.htm