Sat Oct 9 03:04:06 PDT 2010
- Previous message: [Slony1-general] Slonik uninstall node
- Next message: [Slony1-general] How to Call another text file in slon_tools.conf file ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slonik uninstall node
- Next message: [Slony1-general] How to Call another text file in slon_tools.conf file ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list