<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV>Hello. <BR><BR>Thank you for your response. If I understand correctly what
I have to do is this: <BR><BR>On the slon_tool.conf I have only to add
this:<BR><BR></DIV>
<DIV>"set2" => {</DIV>
<DIV>"set_id" => 2,</DIV>
<DIV>"table_id" => 2,</DIV>
<DIV>"sequence_id" => 2,</DIV>
<DIV>"pkeyedtables" => ["testtable"],</DIV>
<DIV>#"keyedtables" => {},</DIV>
<DIV>#"sequences" => [],</DIV>
<DIV>},<BR><BR>And leave everything else intact (set 1, name of cluster, etc).
Then I have to run this commands:<BR><BR># <FONT
style="FONT-SIZE: 11pt">slonik_create_set 2 | slonik</FONT><SPAN
style="mso-spacerun: yes"><FONT style="FONT-SIZE: 11pt"> <BR># </FONT><SPAN
style="LINE-HEIGHT: 13pt; FONT-FAMILY: ; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-fareast-language: en-us; mso-ansi-language: es-mx; mso-bidi-language: ar-sa"><FONT
style="FONT-SIZE: 11pt">slonik_subscribe_set 2 2 | slonik (number of set: 2,
number of node 2)<BR># slonik_subscribe_set 2 3 | slonik (number of set: 2,
number of node 3)</FONT><BR><BR></SPAN></SPAN>Do I have to run slon_kill and
then slon_start ?<BR></DIV>
<DIV>Thanks</DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=gmc@esilibrary.com
href="mailto:gmc@esilibrary.com">Galen Charlton</A> </DIV>
<DIV><B>Sent:</B> Friday, November 09, 2012 9:58 AM</DIV>
<DIV><B>To:</B> <A title=efraindector@motumweb.com
href="mailto:efraindector@motumweb.com">Efraín Déctor</A> </DIV>
<DIV><B>Cc:</B> <A title=slony1-general@lists.slony.info
href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</A>
</DIV>
<DIV><B>Subject:</B> Re: [Slony1-general] Adding a table to replication using
Altperl</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">Hi,
<DIV class=gmail_extra>
<DIV> </DIV>
<DIV class=gmail_quote>On Fri, Nov 9, 2012 at 7:52 AM, Efraín Déctor <SPAN
dir=ltr><<A href="mailto:efraindector@motumweb.com"
target=_blank>efraindector@motumweb.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; FONT-SIZE: 12pt">
<DIV>Hello. I’ve read that it is possible to add a table to a running
replication (<A title=http://slony.info/documentation/2.1/modifyingthings.html
href="http://slony.info/documentation/2.1/modifyingthings.html"
target=_blank>http://slony.info/documentation/2.1/modifyingthings.html</A>),
currently I’m using altperl scripts to manage the replication, I would like to
know if its possible to add a new table using altperl scripts, can you guys
please point me in the right direction?.</DIV></DIV></DIV></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV>One approach to take is to first define a new set in slon_tools.conf that
includes the new table, then use the altperl tools to create the new set,
subscribe nodes to it, then finally (if you want) merge the new set into the
existing replication set. If you do merge sets, the final step is to edit
slon_tools.conf to remove the new set and and move the new table in the existing
set.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><BR>Galen </DIV></DIV>-- <BR>
<DIV>Galen Charlton</DIV>
<DIV>Director of Implementation</DIV>
<DIV>Equinox Software, Inc. / The Open Source Experts</DIV>
<DIV>email: <A href="mailto:gmc@esilibrary.com"
target=_blank>gmc@esilibrary.com</A></DIV>
<DIV>direct: +1 770-709-5581</DIV>
<DIV>cell: +1 404-984-4366</DIV>
<DIV>skype: gmcharlt</DIV>
<DIV>web: <A href="http://www.esilibrary.com/"
target=_blank>http://www.esilibrary.com/</A></DIV>
<DIV>Supporting Koha and Evergreen: <A href="http://koha-community.org"
target=_blank>http://koha-community.org</A> & <A
href="http://evergreen-ils.org" target=_blank>http://evergreen-ils.org</A></DIV>
<DIV> </DIV></DIV></DIV></DIV></DIV></BODY></HTML>