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
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 |