Date: Wed, 17 Nov 2021 11:38:55 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?utf-8?Q?Stanis=C5=82aw?= Kodzis <stanislawk@ntropy.pl>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres14.1 bug with pg_restore and repmgr
Message-ID: <YZRrP46eR+Re8mxF@paquier.xyz>
References: 
 <CAMxe1z5_ZB=tzCnX_nFT3ifeeuC4JqripP4jGa8gOx3G0AQbBg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="72fVYxUIvmf1d5/B"
Content-Disposition: inline
In-Reply-To: 
 <CAMxe1z5_ZB=tzCnX_nFT3ifeeuC4JqripP4jGa8gOx3G0AQbBg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YZRrP46eR%2BRe8mxF%40paquier.xyz>
Precedence: bulk


--72fVYxUIvmf1d5/B
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 16, 2021 at 09:34:33AM +0100, Stanis=C5=82aw Kodzis wrote:
> 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 t=
he
> error(with pg_upgrade cmd on ubuntu 20.4):

There has been no changes related to extensions between 14.0 and 14.1
AFAIK, so that looks like an issue with the extension shipped in
repmgr and its packaging.

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

If you want to speed up things, one thing you could do is perhaps drop
the extension before the upgrade and re-create it on the new cluster
once you are done with pg_upgrade?  It is not uncommon to have
post-upgrade reconfigurations depending on what you are doing.  This
one is a bit extreme, and it may not work if that's a packaging
issue..
--
Michael

--72fVYxUIvmf1d5/B
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmGUaz8ACgkQnvQgOdby
QH3TZQ//UsZZl/X0AhTZLiMKeocy3JttGotnUP+o07B99lRwUyQqgV7CGcIJCv4+
IKDb1MZSoKB2Ib5sDvSulfr1QYGNJ24J/WGDvktP14Y1IyOV2jQrCRhCD4kqTxZt
jnNNVhI3wlur9MvY+hmOl1kFinLYNVUu+zvFc8JplPNcvTzuAeZUpmSog8TMHaj1
KWm9spIyN4WarWrDB9giw4rZ/IMvRkREwKlxMAcoHxtkPPhG2+n4kNvBCF2WO9GC
jBH2M2q/ZLQG0xm8BuekJYYUdzlpixsY4+Fgoh2w4SOL917rTzlxjn2kRZez9rkc
h6SQYVnv54sAFaELUmBiUFxBqYv+sNnFArUUI/5lVRRyx/0c/mW2ZTcFyKCZo16y
ZN41lvS+Q1n3k4ERwqdCGkWm12LUjw/PHgkJ3MSp7p7YjzZGO4d/TwRDstboFVNF
DQdbWcN7i6Uh3i6bK/oSKEAyme68XM4pecghq0WddkfhFqmfOUPY6W1wInOhgkN8
dw75/tcgq3gYrUFXE859ua9tPaPSJdePXsFaDo3dzZosUaam+GqpmeeuIfR7Do9g
R5vqSBDoaULyHcYIbRKN9feomTvus+JwDNZhVVFIzFkjXUgS3cijw2TB9xhaBkiw
tDusGUJzjUemxCqoTCpk24JxbeuHzMFTwQjkEFOBhMft1r61tr0=
=pIXW
-----END PGP SIGNATURE-----

--72fVYxUIvmf1d5/B--