<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: ; COLOR: ">
<DIV>Hello list:</DIV>
<DIV></DIV>
<DIV>My name is Efrain and this week I’ve been using Slony-I, with the help of
the documentation I’ve been able to setup replication between 2 nodes using
slonik scripts and also with altperl scripts. For me, using altperl scritps is
more comfortable but now I’m stucked trying to set cascading replication. I have
this in mind:</DIV>
<DIV></DIV>
<DIV>A1 –> B1 –> B2</DIV>
<DIV></DIV>
<DIV>Meaning that A1 would be the master to B1 but also B1 would be master of
B2. My slon_tools.conf looks like this:</DIV>
<DIV></DIV>
<DIV>add_node(node => 1,</DIV>
<DIV>host => '192.168.1.231',</DIV>
<DIV>dbname => 'prueba',</DIV>
<DIV>port => 5432,</DIV>
<DIV>user => 'postgres',</DIV>
<DIV>password => '1');</DIV>
<DIV></DIV>
<DIV>add_node(node => 2,</DIV>
<DIV>host => '192.168.1.232',</DIV>
<DIV>dbname => 'prueba',</DIV>
<DIV>port => 5432,</DIV>
<DIV>noforward => allow,</DIV>
<DIV>user => 'pgsql',</DIV>
<DIV>password => '2');</DIV>
<DIV></DIV>
<DIV>add_node(node => 3,</DIV>
<DIV>parent => 2,</DIV>
<DIV>host => '192.168.1.233',</DIV>
<DIV>dbname => 'prueba',</DIV>
<DIV>port => 5432,</DIV>
<DIV>user => 'pgsql',</DIV>
<DIV>password => '3');</DIV>
<DIV></DIV>
<DIV>I understand that B1 shall be configured to accept forward but I don’t now
how to do this.</DIV>
<DIV></DIV>
<DIV>Any help would be really appreciated.</DIV>
<DIV></DIV>
<DIV>Thank you.</DIV></DIV></DIV></DIV></BODY></HTML>