Hello. I just wanted to let you know that thanks to your advice adding new tables to the replication has worked perfectly, including merging the sets.

Thanks a lot.

From: Galen Charlton 
Sent: Friday, November 09, 2012 10:28 AM
To: Efraín Déctor 
Cc: slony1-general at lists.slony.info 
Subject: Re: [Slony1-general] Adding a table to replication using Altperl

Hi, 



On Fri, Nov 9, 2012 at 8:26 AM, Efraín Déctor <efraindector at motumweb.com> wrote:

  Thank you for your response. If I understand correctly what I have to do is this: 

  On the slon_tool.conf I have only to add this:


  "set2" => {
  "set_id" => 2,
  "table_id" => 2,
  "sequence_id" => 2,
  "pkeyedtables" => ["testtable"],
  #"keyedtables" => {},
  #"sequences" => [],
  },


I think you'll need to increase the table_id and sequence_ids to account for the tables already in set1.

  # slonik_create_set 2 | slonik 
  # slonik_subscribe_set 2 2 | slonik (number of set: 2, number of node 2)
  # slonik_subscribe_set 2 3 | slonik (number of set: 2, number of node 3)

Yes.

  Do I have to run slon_kill and then slon_start ?


No, that won't be necessary.

Regards,

Galen
-- 

Galen Charlton
Director of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20121109/50bd27ae/attachment.htm