Hi,

I have configured Slony-II using altperl tools. I am trying to add a new
table to a running replication using following steps:

1.
 ./slonik_execute_script --config slon_tools.conf 1
/usr/pgsql-9.2/bin/test.sql | ./slonik             (sql file has only
create table command)
<stdin>:4: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"ddl_slony_pkey" for table "ddl_slony"

2.
Adding the table in the slon_tools.conf file as set2 below set1:

 "set2" => {
       "set_id"       => 2,
       "table_id"     => 2,
       "sequence_id"  => 2,
       "pkeyedtables" => ["public.ddl_slony"],
       "keyedtables"  => {},
       "sequences"    => [],
    },

3. While executing create set, I am getting the following error:

 ./slonik_create_set -c slon_tools.conf 2 | ./slonik

<stdin>:11: Subscription set 2 created
<stdin>:12: Adding tables to the subscription set
<stdin>:13: PGRES_FATAL_ERROR lock table
"_ms_prod_slony".sl_config_lock;select "_ms_prod_slony".setAddTable(2, 2,
'public.ddl_slony', 'ddl_slony_pkey', 'Table public.ddl_slony with primary
key');  - ERROR:  Slony-I: setAddTable_int: table id 2 has already been
assigned!
CONTEXT:  SQL statement "SELECT "_ms_prod_slony".setAddTable_int(p_set_id,
p_tab_id, p_fqname,
                        p_tab_idxname, p_tab_comment)"
PL/pgSQL function
_ms_prod_slony.setaddtable(integer,integer,text,name,text) line 28 at
PERFORM

I tried the above by manually creating another table on both nodes and
adding and creating set as set3. Still facing the same issue.

Can anybody point out where I am going wrong and how it should be fixed?

Thanks,
GB
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20130514/0ff2cde0/attachment.htm