Hi Adrian, did you maintain one of the replicas up and running with 9.3 version?
> On 17 Oct 2021, at 11:24, Videanu Adrian <[email protected]> wrote: > > Hi All, > > I have a master-master postgresql bucardo (version 5.4.1) cluster. > > This morning I replaced one of the servers that were running PostgreSQL 9.3 > with one the is running PostgreSQL 13. > The procedure was the following: > > 1. Bucardo was stopped > 2. Export all the databases from old server (pg_dump -Fc ....) > 3. Import all the databases to new server > 4. switch the old server IP to new server (so that for bucardo we would have > the same connection info) > 5. start bucardo > > it seems that aonce started I got errors like: > > (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 > LINE 1: DELETE FROM bucardo.delta_pg_toast_pg_toast_50507 USING (SEL... > ^ > 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' > CONTEXT: PL/pgSQL function bucardo.bucardo_purge_delta_oid(text,oid) line 49 > at EXECUTE > SQL statement "SELECT bucardo.bucardo_purge_delta_oid($1, > myrec.tablename)" > PL/pgSQL function bucardo_purge_delta(text) line 12 at SQL statement at > /usr/local/lib64/perl5/5.20.2/Bucardo.pm line 7737. > > > > > Any idea how should I proceed? > > Regards, > Adrian Videanu > Skype: videanu.adrian > Tel:+40723864025 > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://bucardo.org/mailman/listinfo/bucardo-general
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
