Hi i had some experience in upgrading from 1.2 to 2.0, similar to the above post:<br><br><div class="gmail_quote">On Fri, Aug 12, 2011 at 8:28 AM, Christopher Browne <span dir="ltr"><<a href="mailto:cbbrowne@afilias.info">cbbrowne@afilias.info</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div></div><br></div>
I had started efforts on a would-be methodology to upgrade the Slony<br>
schema, but it was getting complex enough, including requiring some<br>
steps outside Slony (e.g. - the log triggers and XXID visibility<br>
functions changed in ways that would be really troublesome to cope<br>
with) that we concluded it wasn't realistic to "upgrade" but rather to<br>
drop replication and reinstall Slony. <br><br></blockquote><div><br>I pretty much upgraded the same way i.e. dropped the working
replication, deleted version slony1 using apt-get remove purge and
apt-get installed the newer version slony1-2. After that i tried adding
the new entries to the replicated database, but i kept on getting this
error.<br><br>2011-08-12 08:59:59 PDT ERROR: type "_four_node_rep_cluster1221.xxid" does not exist<br>2011-08-12 08:59:59 PDT STATEMENT: insert into contact (cid, name, address,<br> phonenumber) values ((select nextval('contact_seq')),<br>
'Robert', '4 Bar Roard', '(515) 821-3831');<br>ERROR: type "_four_node_rep_cluster1221.xxid" does not exist<br><br>The replication cluster being used (as shown in the error) is _four_node_rep_cluster1221 whereas i configured and started a new replication cluster _four_node_rep_cluster2041 for the newer version, 2.0.4.1. So
i am guessing this is because of the XXID visibilty function changes in
the versions from 1.2 to 2.0. Does this mean that I cant make changes to the database being used when i switch over to slony1-2 version? <br><br>Let me know if am doing anything wrong or missing anything because this pretty much means that i cannot upgrade slony on the live database without deleting replication schemas or creating new database.<br>
<br>Regards<br>Dilraj Singh<br> </div></div>