raghavendra t raagavendra.rao at gmail.com
Sat Oct 9 03:04:06 PDT 2010
Hi All,

I am using slony with perltools.

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.

*Question*

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".

My Testing
========
1. Created a tables file "tab.txt" with set of replicating primary key
tables.

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

$CLUSTER_NAME = 'firstreplic';
$LOGDIR = '/var/log/slony';
$MASTERNODE = 1;
$DEBUGLEVEL = 2;
*$TABLEFILE = '/usr/local/pgsql/bin/tab.txt';*

&add_node(node => 1,host => 'localhost',dbname => 'master',port => 5455,user
=> 'postgres',password => '');
&add_node(node => 2,host => 'localhost',dbname => 'slave',port => 5456,user
=> 'postgres',password => '');

$SLONY_SETS =
{
    "set1" =>
    {
        "set_id" => 1,
        "table_id" => 1,
        "pkeyedtables" =>
                       * [$TABLEFILE,],*
    }
};

Kindly assist me, how to achieve this task.

Best Regards

Raghav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101009/2c19a33e/attachment.htm 


More information about the Slony1-general mailing list