Lawrence,

You don't put the subscribe set into the init script. It should be a separa=
te script.

The way I usually do things is to =

1. run the init script (everything you have except subscribe) on the master
2. Start the slon process on the master and slave(s)
3. Run the subscribe script on the master.

Melvin Davidson =

 =

 Folk Alley - All Folk - 24 Hours a day =

www.folkalley.com



--- On Wed, 7/8/09, Lawrence Wong <lawrencew00 at hotmail.com> wrote:

From: Lawrence Wong <lawrencew00 at hotmail.com>
Subject: [Slony1-general] Slony-I will not replicate more than 1 table
To: slony1-general at lists.slony.info
Date: Wednesday, July 8, 2009, 10:16 PM




#yiv1543896473 .hmmessage P
{
margin:0px;padding:0px;}
#yiv1543896473 {
font-size:10pt;font-family:Verdana;}

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.=A0 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,
=A0=A0=A0 conninfo =3D 'dbname=3DDB host=3D10.5.11.20 user=3Dpg password=3D=
pg');
store path ( server =3D 2, client =3D 1,
=A0=A0=A0 conninfo =3D 'dbname=3DDB host=3D10.5.11.21 user=3Dpg password=3D=
pg');

#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.=A0 But it does not replicate.=A0 Th=
e other thing I want to mention is that when I comment one of the lines whi=
ch adds a table, say 'set add table (set id=3D1, origin=3D1, id=3D4, fully =
qualified name =3D 'sample.table2',comment=3D'');', the replication works f=
or 'sample.table1'.=A0 When I uncomment the line with 'sample.table2' and c=
omment out the set add line for 'sample.table1' -- replication works for sa=
mple.table2.=A0 =


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.=A0 But if I have just 1 table, ei=
ther table 1 or table 2.=A0 Slony-I replication works.=A0 Can anyone give m=
e any hints on what to do?

LW . . . Lawrence

Stay on top of things, check email from other accounts! Check it out. =


-----Inline Attachment Follows-----

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090708/=
929942ba/attachment.htm