Postgres14.1 bug with pg_restore and repmgr

Поиск
Список
Период
Сортировка
От Stanisław Kodzis
Тема Postgres14.1 bug with pg_restore and repmgr
Дата
Msg-id CAMxe1z5_ZB=tzCnX_nFT3ifeeuC4JqripP4jGa8gOx3G0AQbBg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres14.1 bug with pg_restore and repmgr  (Michael Paquier <michael@paquier.xyz>)
Список 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



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: References to parameters by name are lost in INSERT INTO ... SELECT .... statements in case of routines with the SQL-standard function body
Следующее
От: Dave Page
Дата:
Сообщение: Re: Tenable Report Issue even after upgrading to correct Postgres version