My bad, I just started using slony and bypassed that common sense 
implication =-D. Thanks for the guide and for bearing with newbies. No 
bug whatsoever.

El 05/08/11 16:09, Steve Singer escribió:
> On 11-08-05 04:38 PM, Rene Romero Benavides wrote:
>> Hello everybody and greetings from México City.
>>
>> *slony version: 2.0.7 with postgresql 9.0.4 running on debian squeeze
>> (and same issue arises with opensuse 11.04)*
>> I get the following message when trying to subscribe a node to a
>> replication set:
>>
>> *<stdin>:4: row number 0 is out of range 0..-1
>> Segmentation fault*
>>
>
> I don't see a 'create set(....)'  slonik command anywhere in the below 
> output.  The altperl script slonik_create_set command generates this. 
> Did you forget to run it befure you tried subscribing?
>
> (if this is the case and slonik is generating a segmentation fault 
> instead of a useful error message then that is a bug)
>
> Steve
>
>> the slony instructions (generated with perltools) that caused this 
>> error:/
>> /----------------------------------------------------------------------------------------------------- 
>>
>> /cluster name = slony_cluster;
>> node 1 admin conninfo='host=10.0.0.142 dbname=pgbench user=postgres
>> port=5432 password=postgres';
>> node 2 admin conninfo='host=10.0.0.140 dbname=pgbenchslave user=postgres
>> port=5432 password=postgres';
>> try {
>> subscribe set (id = 1, provider = 1, receiver = 2, forward = yes);
>> }
>> on error {
>> exit 1;
>> }
>> echo 'Subscribed nodes to set 1';/
>> ----------------------------------------------------------------------------------------------------- 
>>
>>
>> And my slon_tools.conf
>> ----------------------------------------------------------------------------------------------------- 
>>
>>
>> if ($ENV{"SLONYNODES"}) {
>> require $ENV{"SLONYNODES"};
>> } else {
>>
>> $CLUSTER_NAME = 'slony_cluster';
>>
>> $LOGDIR = '/var/log/slony1';
>>
>> $MASTERNODE = 1;
>>
>> $DEBUGLEVEL = 2;
>>
>> add_node(node => 1,
>> host => '10.0.0.142',
>> dbname => 'pgbench',
>> port => 5432,
>> user => 'postgres',
>> password => 'postgres');
>>
>> add_node(node => 2,
>> host => '10.0.0.140',
>> dbname => 'pgbenchslave',
>> port => 5432,
>> user => 'postgres',
>> password => 'postgres');
>> }
>>
>>
>> $SLONY_SETS = {
>> "set1" => {
>> "set_id" => 1,
>> "table_id" => 1,
>> "sequence_id" => 1,
>> "pkeyedtables" => [
>> 'pgbench_tellers',
>> 'pgbench_history',
>> 'pgbench_accounts',
>> 'pgbench_branches'
>> ],
>> },
>> };
>>
>> if ($ENV{"SLONYSET"}) {
>> require $ENV{"SLONYSET"};
>> }
>> # Please do not add or change anything below this point.
>> 1;
>> ----------------------------------------------------------------------------------------------------- 
>>
>> When I fire up the script I get:
>> 2011-08-05 15:26:20 CDT LOG: unexpected EOF on client connection
>> on the slon logs from the master node (where I'm calling it from)
>>
>> I've checked connectivity between nodes and everything is alright. I've
>> ran other scripts such as slonik_uninstall_nodes, slonik_drop_node, and
>> slonik_add_node and they're executed successfully.
>>
>> The cluster was previously initialized with:
>> ----------------------------------------------------------------------------------------------------------------------- 
>>
>> # INIT CLUSTER
>> cluster name = slony_cluster;
>> node 1 admin conninfo='host=10.0.0.142 dbname=pgbench user=postgres
>> port=5432 password=postgres';
>> node 2 admin conninfo='host=10.0.0.140 dbname=pgbenchslave user=postgres
>> port=5432 password=postgres';
>> init cluster (id = 1, comment = 'Node 1 - pgbench at 10.0.0.142');
>>
>> # STORE NODE
>> store node (id = 2, event node = 1, comment = 'Node 2 -
>> pgbenchslave at 10.0.0.140');
>> echo 'Set up replication nodes';
>>
>> # STORE PATH
>> echo 'Next: configure paths for each node/origin';
>> store path (server = 1, client = 2, conninfo = 'host=10.0.0.142
>> dbname=pgbench user=postgres port=5432 password=postgres');
>> store path (server = 2, client = 1, conninfo = 'host=10.0.0.140
>> dbname=pgbenchslave user=postgres port=5432 password=postgres');
>> echo 'Replication nodes prepared';
>> echo 'Please start a slon replication daemon for each node';
>> ----------------------------------------------------------------------------------------------------------------------- 
>>
>> The slon daemon is running on both nodes.
>>
>> Any help will be highly appreciated. Thanks
>>
>>
>>
>>
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>