<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Adrian, did you maintain one of the replicas up and running with 9.3 version?<div class=""><br class=""></div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 17 Oct 2021, at 11:24, Videanu Adrian <<a href="mailto:videanuadrian@yahoo.com" class="">videanuadrian@yahoo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><div class="ydp65780c7ayahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div class=""><div dir="ltr" data-setdir="false" class="">Hi All, <br class=""></div><div dir="ltr" data-setdir="false" class=""><br class=""><div dir="ltr" data-setdir="false" class="">I have a master-master postgresql bucardo (<span class="">version 5.4.1</span>) cluster.</div><div dir="ltr" data-setdir="false" class=""><br class=""><div class="">This morning I replaced one of the servers that were running PostgreSQL 9.3 with one the is running PostgreSQL 13.</div><div dir="ltr" data-setdir="false" class=""> The procedure was the following:</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">1. Bucardo was stopped</div><div dir="ltr" data-setdir="false" class="">2. Export all the databases from old server (pg_dump -Fc ....)<br class=""></div><div dir="ltr" data-setdir="false" class="">3. Import all the databases to new server</div><div dir="ltr" data-setdir="false" class="">4. switch the old server IP to new server (so that for bucardo we would have the same connection info)<br class=""></div><div dir="ltr" data-setdir="false" class="">5. start bucardo</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">it seems that aonce started I got errors like: <br class=""></div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class=""><div class="">(6266) [Sun Oct 17 12:13:39 2021] VAC Warning! VAC was killed at line 7737: DBD::Pg::st pg_result failed: ERROR: relation "bucardo.delta_pg_toast_pg_toast_50507" does not exist<br class="">LINE 1: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SEL...<br class=""> ^<br class="">QUERY: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SELECT txntime AS tt FROM bucardo.track_pg_toast_pg_toast_50507 GROUP BY 1 HAVING COUNT(*) = 1) AS foo WHERE txntime = tt AND txntime < now() - interval '45 seconds'<br class="">CONTEXT: PL/pgSQL function bucardo.bucardo_purge_delta_oid(text,oid) line 49 at EXECUTE<br class="">SQL statement "SELECT bucardo.bucardo_purge_delta_oid($1, myrec.tablename)"<br class="">PL/pgSQL function bucardo_purge_delta(text) line 12 at SQL statement at /usr/local/lib64/perl5/5.20.2/Bucardo.pm line 7737.</div><div class=""><br class=""></div></div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class=""><br class=""></div></div></div><div class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">Any idea how should I proceed? <br class=""></div><div class="ydp65780c7asignature"><div style="font-family:Helvetica, Arial, sans-serif;font-size:13px;" class=""><div class=""><br class=""> </div><span class=""><div class="ydp744c546bsignature">Regards,</div><div class="ydp744c546bsignature"> Adrian Videanu</div><div class="ydp744c546bsignature"><span class="">Skype: videanu.adrian</span></div></span><div class=""><span class=""><span class="">Tel:+40723864025</span></span></div></div></div></div></div></div>_______________________________________________<br class="">Bucardo-general mailing list<br class=""><a href="mailto:Bucardo-general@bucardo.org" class="">Bucardo-general@bucardo.org</a><br class="">https://bucardo.org/mailman/listinfo/bucardo-general<br class=""></div></blockquote></div><br class=""></div></body></html>