<html><head></head><body><div class="ydp65780c7ayahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div><div dir="ltr" data-setdir="false">Hi All, <br></div><div dir="ltr" data-setdir="false"><br><div dir="ltr" data-setdir="false">I have a master-master postgresql bucardo (<span>version 5.4.1</span>) cluster.</div><div dir="ltr" data-setdir="false"><br><div>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"> The procedure was the following:</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">1. Bucardo was stopped</div><div dir="ltr" data-setdir="false">2. Export all the databases from old server (pg_dump -Fc ....)<br></div><div dir="ltr" data-setdir="false">3. Import all the databases to new server</div><div dir="ltr" data-setdir="false">4. switch the old server IP to new server (so that for bucardo we would have the same connection info)<br></div><div dir="ltr" data-setdir="false">5. start bucardo</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">it seems that aonce started I got errors like: <br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><div>(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>LINE 1: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SEL...<br> ^<br>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>CONTEXT: PL/pgSQL function bucardo.bucardo_purge_delta_oid(text,oid) line 49 at EXECUTE<br>SQL statement "SELECT bucardo.bucardo_purge_delta_oid($1, myrec.tablename)"<br>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><br></div></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div></div></div><div><br></div><div dir="ltr" data-setdir="false">Any idea how should I proceed? <br></div><div class="ydp65780c7asignature"><div style="font-family:Helvetica, Arial, sans-serif;font-size:13px;"><div><br> </div><span><div class="ydp744c546bsignature">Regards,</div><div class="ydp744c546bsignature"> Adrian Videanu</div><div class="ydp744c546bsignature"><span>Skype: videanu.adrian</span></div></span><div><span><span>Tel:+40723864025</span></span></div></div></div></div></div></body></html>