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)\
From:
Masahiko Sawada Date: Subject:
Re: References to parameters by name are lost in INSERT INTO ... SELECT .... statements in case of routines with the SQL-standard function body