Hi,

My set up is a simple 1 master and 1 slave set up using Postgres 8.3 with S=
lony-I 1.2.15 on 2 Windows 2003 Servers.  My slonik script looks like:

cluster name =3D slony_db1;
node 1 admin conninfo=3D'host=3D10.5.11.20 dbname=3DDB user=3Dpg password=
=3Dpg';
node 2 admin conninfo=3D'host=3D10.5.11.21 dbname=3DDB user=3Dpg password=
=3Dpg';

init cluster (id=3D1,comment=3D'node 1');

#CREATE SET
create set (id =3D 1, origin =3D 1, comment =3D 'tables');

#SET ADD TABLE
set add sequence (set id=3D1, origin=3D1, id=3D1, fully qualified name =3D =
'sample.seq_1', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D2, fully qualified name =3D =
'sample.seq_2', comment=3D'');
set add table (set id=3D1, origin=3D1, id=3D3, fully qualified name =3D 'sa=
mple.table1',comment=3D'');
set add table (set id=3D1, origin=3D1, id=3D4, fully qualified name =3D 'sa=
mple.table2',comment=3D'');

#STORE NODE
store node ( id =3D 2, comment =3D 'node 2' );

#STORE PATH
store path ( server =3D 1, client =3D 2,
    conninfo =3D 'dbname=3DDB host=3D10.5.11.20 user=3Dpg password=3Dpg');
store path ( server =3D 2, client =3D 1,
    conninfo =3D 'dbname=3DDB host=3D10.5.11.21 user=3Dpg password=3Dpg');

#STORE LISTEN
store listen ( origin =3D 1, provider =3D 1, receiver =3D 2 );
store listen ( origin =3D 2, provider =3D 2, receiver =3D 1 );

#SUBSCRIBE SET
subscribe set (id=3D1, provider=3D1, receiver=3D2, forward=3Dno);

I run the slonik script with no errors.  But it does not replicate.  The ot=
her thing I want to mention is that when I comment one of the lines which a=
dds a table, say 'set add table (set id=3D1, origin=3D1, id=3D4, fully qual=
ified name =3D 'sample.table2',comment=3D'');', the replication works for '=
sample.table1'.  When I uncomment the line with 'sample.table2' and comment=
 out the set add line for 'sample.table1' -- replication works for sample.t=
able2.  =


What I am saying is, when I try to do replication with more then 1 table, S=
lony-I will not replicate changes for me.  But if I have just 1 table, eith=
er table 1 or table 2.  Slony-I replication works.  Can anyone give me any =
hints on what to do?

LW . . . Lawrence

_________________________________________________________________
Stay on top of things, check email from other accounts!
http://go.microsoft.com/?linkid=3D9671355
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090709/=
5d518524/attachment.htm