Postgres14.1 bug with pg_restore and repmgr

From: Stanisław Kodzis <stanislawk(at)ntropy(dot)pl>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Postgres14.1 bug with pg_restore and repmgr
Date: 2021-11-16 08:34:33
Message-ID: CAMxe1z5_ZB=tzCnX_nFT3ifeeuC4JqripP4jGa8gOx3G0AQbBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

There was 14.1 couple days ago and it affected my upgrade from 9.6 to 14.
On 14.0 there was smooth upgrade - now after apt upgrade to 14.1 I have the
error(with pg_upgrade cmd on ubuntu 20.4):

pg_restore: error: could not execute query: ERROR: could not find
function "get_local_node_id" in file
"/usr/lib/postgresql/14/lib/repmgr.so"

Command was: CREATE FUNCTION "repmgr"."get_local_node_id"() RETURNS integer

LANGUAGE "c" STRICT

AS '$libdir/repmgr', 'get_local_node_id';

-- For binary upgrade, handle extension membership the hard way

ALTER EXTENSION "repmgr" ADD FUNCTION "repmgr"."get_local_node_id"();

I dunno how to implement this (on 9.6 is already registered)
ALTER EXTENSION "repmgr"
If I register it on 14.1 pg_upgrade won't allow me to continue upgrade.

Did the bug appear because of not upgraded package :

postgresql-14-repmgr-dbgsym is already the newest version
(5.3.0-1.pgdg20.04+1) \

shouldn't it be 5.3.1-1 ?

Looking forward to reading from you.

Kind regards,

Stanisław Kodzis

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2021-11-16 09:11:05 Re: Tenable Report Issue even after upgrading to correct Postgres version
Previous Message Masahiko Sawada 2021-11-16 06:52:56 Re: References to parameters by name are lost in INSERT INTO ... SELECT <parameter value> .... statements in case of routines with the SQL-standard function body