Hi All,<div><br></div><div>I am using slony with perltools.</div><div><br></div><div>I have taken the sample file from the "/usr/local/src/slony1-2.0.4/tools/altperl/slon_tools.conf-sample" and modified as per my requirement.</div>
<div><br></div><div><u>Question</u></div><div><br></div><div>In the place of Tables list/Sequenst list. Can I use any text file which contain all the tables information. If yes, how could I pass the test file to the "slon_tools.conf-sample".</div>
<div><br></div><div>My Testing</div><div>========</div><div>1. Created a tables file "tab.txt" with set of replicating primary key tables.</div><div><br></div><div>2. Edited the "slon_tools.conf-sample" and trying to send the "tab.txt" file. Below is the "slon_tools.conf-sample" file I am trying to use</div>
<div><br></div><div>$CLUSTER_NAME = 'firstreplic';</div><div><div>$LOGDIR = '/var/log/slony';</div><div>$MASTERNODE = 1;</div><div>$DEBUGLEVEL = 2;</div><div><font class="Apple-style-span" color="#CC0000"><b>$TABLEFILE = '/usr/local/pgsql/bin/tab.txt';</b></font></div>
<div><br></div><div>&add_node(node => 1,host => 'localhost',dbname => 'master',port => 5455,user => 'postgres',password => '');</div><div>&add_node(node => 2,host => 'localhost',dbname => 'slave',port => 5456,user => 'postgres',password => '');</div>
<div><br></div><div>$SLONY_SETS =</div><div>{</div><div> "set1" =></div><div> {</div><div> "set_id" => 1,</div><div> "table_id" => 1,</div><div> "pkeyedtables" =></div>
<div> <font class="Apple-style-span" color="#CC0000"><b> [$TABLEFILE,],</b></font></div><div> }</div><div>};</div></div><div><br></div><div>Kindly assist me, how to achieve this task.</div><div><br>
</div><div>Best Regards</div><div><div><br></div><div>Raghav</div><div><br></div><br>
</div>