Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkWrX-0007Wh-Fs for pgsql-admin@arkaria.postgresql.org; Tue, 09 Nov 2021 19:32:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mkWrV-0001rV-Lo for pgsql-admin@arkaria.postgresql.org; Tue, 09 Nov 2021 19:32:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkWrV-0001np-6y for pgsql-admin@lists.postgresql.org; Tue, 09 Nov 2021 19:32:53 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mkWrS-00050X-56 for pgsql-admin@lists.postgresql.org; Tue, 09 Nov 2021 19:32:51 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id A90C7380550; Tue, 9 Nov 2021 20:32:47 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id XqtbwbQb--DY; Tue, 9 Nov 2021 20:32:47 +0100 (CET) Received: from [192.168.178.86] (p5b2455b7.dip0.t-ipconnect.de [91.36.85.183]) by rs.plausibolo.de (Postfix) with ESMTPSA id 5839E380485; Tue, 9 Nov 2021 20:32:47 +0100 (CET) Message-ID: Date: Tue, 9 Nov 2021 20:32:46 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.2.0 Subject: Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist. Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <28768e4f-f6f7-ad78-d0dc-169954a06156@gisticinc.com> <8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com> <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com> From: Holger Jakobs In-Reply-To: <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------zyBlp5MRCkdzxFImSNLu0U55" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------zyBlp5MRCkdzxFImSNLu0U55 Content-Type: multipart/mixed; boundary="------------foLR0loq50G13MiVDGjLUuBg"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist. References: <28768e4f-f6f7-ad78-d0dc-169954a06156@gisticinc.com> <8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com> <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com> In-Reply-To: <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com> --------------foLR0loq50G13MiVDGjLUuBg Content-Type: multipart/alternative; boundary="------------3P9OQMXJ5LNY4uiVP1Lr0Pog" --------------3P9OQMXJ5LNY4uiVP1Lr0Pog Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMDkuMTEuMjEgdW0gMTg6NTAgc2NocmllYiBCbyBHdW86DQo+DQo+IFJvbiwNCj4NCj4g VWJ1bnR1IHJlbGVhc2UgdXBncmFkZSAoZG8tcmVsZWFzZS11cGdyYWRlKSB1c2VzIFVidW50 dSBvZmZpY2lhbCANCj4gcmVwb3NpdG9yeSwgSSBiZWxpZXZlLg0KPg0KPiBCbw0KPg0KPiBP biAxMS85LzIxIDEwOjE2IEFNLCBSb24gd3JvdGU6DQo+PiBPbiAxMS85LzIxIDEwOjIzIEFN LCBCbyBHdW8gd3JvdGU6DQo+Pj4NCj4+PiBIZWxsbyBDb21tdW5pdHkhDQo+Pj4NCj4+PiBP bmUgb2YgbXkgUG9zdGdyZXNxbCBzZXJ2ZXJzIGhhcyBiZWVuIG92ZXIgdGhlIHllYXJzIHRo cm91Z2ggDQo+Pj4gImluLXBsYWNlIiB1cGRhdGUgZm9yIGxhc3QgNiB5ZWFycyBvciBzby7C oCBDdXJyZW50bHkgc3RhbmRzIGF0IDE4LjA0IA0KPj4+IHcvIFBvc3RncmVzLTEyLVBvc3Rn aXMgMy4xLCB0aGUgc2VydmVyIHdlbnQgdGhyb3VnaCBtdWx0aXBsZSB2ZXJzaW9uIA0KPj4+ IG9zIFVidW50dSBhbmQgUG9zdGdyZVNRTCAuDQo+Pj4NCj4+PiBJIGFtIHRyeWluZyB0byB1 cGdyYWRlIFVidW50dSB0byAyMC4wNCBmaXJzdCBiZWZvcmUgdXBncmFkaW5nIA0KPj4+IFBv c3RncmVTUUwsIGJ1dCBmYWlsZWQgd2l0aCBPUyB1cGdyYWRlLsKgIEhlcmUgYXJlIHRoZSBs YXN0IGZldyBsaW5lcyANCj4+PiBpbiAvdmFyL2xvZy9kaXN0LXVwZ3JhZGUvbWFpbi5sb2cg YWZ0ZXIgZmFpbGVkIHVwZ3JhZGU6DQo+Pj4NCj4+PiAyMDIxLTExLTA5IDA4OjM1OjUwLDA0 NCBERUJVRyBibGFja2xpc3QgZXhwciAnXnBvc3RncmVzcWwtLipbMC05XVswLTldLionIG1h dGNoZXMgJ3Bvc3RncmVzcWwtMTItcG9zdGdpcy0zJw0KPj4+IDIwMjEtMTEtMDkgMDg6MzU6 NTAsMDQ0IERFQlVHIFRoZSBwYWNrYWdlICdwb3N0Z3Jlc3FsLTEyLXBvc3RnaXMtMycgaXMg bWFya2VkIGZvciByZW1vdmFsIGJ1dCBpdCdzIGluIHRoZSByZW1vdmFsIGJsYWNrbGlzdA0K Pj4+IDIwMjEtMTEtMDkgMDg6MzU6NTAsMDUzIEVSUk9SIERpc3QtdXBncmFkZSBmYWlsZWQ6 ICdUaGUgcGFja2FnZSAncG9zdGdyZXNxbC0xMi1wb3N0Z2lzLTMnIGlzIG1hcmtlZCBmb3Ig cmVtb3ZhbCBidXQgaXQgaXMgaW4gdGhlIHJlbW92YWwgYmxhY2tsaXN0LicNCj4+PiAyMDIx LTExLTA5IDA4OjM1OjUwLDA1NSBERUJVRyBhYm9ydCBjYWxsZWQNCj4+Pg0KPj4+IFRoZSBv ZmZlbmRpbmcgcGFja2FnZcKgICdwb3N0Z3Jlc3FsLTEyLXBvc3RnaXMtMycgY29ycmVzcG9u ZHMgbXkgDQo+Pj4gY3VycmVudCBQb3N0Z3Jlc3FsIHZlcnNpb24uwqAgU2hvdWxkIEkgcmVt b3ZlIHRoZSBwYWNrYWdlIGFuZCBwcm9jZWVkIA0KPj4+IHdpdGggT1MgdXBncmFkZT/CoCBJ IGFtIGF0IGEgbG9zcy4uLg0KPj4+DQo+Pg0KPj4gV2hhdCByZXBvc2l0b3J5IGRpZCB5b3Ug aW5zdGFsbCBpdCBmcm9tPw0KPj4NCj4+IC0tIA0KPj4gQW5ndWxhciBtb21lbnR1bSBtYWtl cyB0aGUgd29ybGQgZ28gJ3JvdW5kLg0KPiAtLSANCj4gUmVnYXJkcywNCj4NCj4gQm8gR3Vv LCBQaEQsIFBFDQo+IFByZXNpZGVudA0KPiBHaXN0aWMgUmVzZWFyY2gsIEluYy4NCj4gMjAz MyBFIFdhcm5lciBSZCBTdGUgMTA1DQo+IFRlbXBlLCBBWiA4NTI4NA0KPiB3d3cuZ2lzdGlj aW5jLmNvbQ0KPiB3d3cueW91dHViZS5jb20vbGluZWFyYmVuY2gNCj4gT2ZmaWNlOiA0ODAt NjU2LTk5NjINCj4gQ2VsbDogNjAyLTU3MC00Njk3DQoNCkkgd291bGQgc3Ryb25nbHkgcmVj b21tZW5kIHRvIHVzZSB0aGUgcmVwb3NpdG9yeSBvZiB0aGUgUG9zdGdyZVNRTCANCkRldmVs b3BlciBHcm91cDogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG93bmxvYWQvbGludXgv dWJ1bnR1Lw0KDQpUaGlzIG1ha2VzIHlvdXIgT1MgdXBncmFkZXMgYW5kIHRoZSBQb3N0Z3Jl U1FMIHVwZGF0ZXMgbW9yZSBpbmRlcGVuZGVudCANCm9mIGVhY2ggb3RoZXIuIFBsdXMsIHlv dSBhbHdheXMgY2FuIGdldCB0aGUgbGF0ZXN0IFBvc3RncmVTUUwgdmVyc2lvbiwgDQp3aGls ZSB0aGUgZGlzdHJpYnV0aW9uIHJlcG9zaXRvcmllcyBvbmx5IG9mZmVyIHRoZSBjdXJyZW50 IHZlcnNpb24gYXMgb2YgDQppdHMgcHVibGlzaGluZy4gU28sIFVidW50dSAyMC4wNCBvbmx5 IGhhcyB0aGUgMjAxOSB2ZXJzaW9uIG9mIFBvc3RncmVTUUwuDQoNCi0tIA0KDQpIb2xnZXIg SmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K --------------3P9OQMXJ5LNY4uiVP1Lr0Pog Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Am 09.11.21 um 18:50 schrieb Bo Guo:

Ron,

Ubuntu release upgrade (do-release-upgrade) uses Ubuntu official repository, I believe.

Bo

On 11/9/21 10:16 AM, Ron wrote:
On 11/9/21 10:23 AM, Bo Guo wrote:

Hello Community!

One of my Postgresql servers has been over the years through "in-place" update for last 6 years or so.=C2=A0 Curre= ntly stands at 18.04 w/ Postgres-12-Postgis 3.1, the server went through multiple version os Ubuntu and PostgreSQL .

I am trying to upgrade Ubuntu to 20.04 first before upgrading PostgreSQL, but failed with OS upgrade.=C2=A0 Here = are the last few lines in /var/log/dist-upgrade/main.log after failed upgrade:

2021-11-09 08:35:50,044 DEBUG blacklist expr '^postgresql-=
=2E*[0-9][0-9].*' matches 'postgresql-12-postgis-3'
2021-11-09 08:35:50,044 DEBUG The package 'postgresql-12-p=
ostgis-3' is marked for removal but it's in the removal blacklist
2021-11-09 08:35:50,053 ERROR Dist-upgrade failed: 'The pa=
ckage 'postgresql-12-postgis-3' is marked for removal but it is in the re=
moval blacklist.'
2021-11-09 08:35:50,055 DEBUG abort called

The offending package=C2=A0 'postgresql-12-postgis-3' corresponds my current Postgresql version.=C2=A0 Should I rem= ove the package and proceed with OS upgrade?=C2=A0 I am at a loss= =2E..=C2=A0


What repository did you install it from?=C2=A0

--
Angular momentum makes the world go 'round.
--=20
Regards,

Bo Guo, PhD, PE
President
Gistic Research, Inc.
2033 E Warner Rd Ste 105
Tempe, AZ 85284
www.gisticinc.com
www.youtube.com/linearbench
Office: 480-656-9962
Cell: 602-570-4697

I would strongly recommend to use the repository of the PostgreSQL Developer Group: https://www.postgresql.org/download/linux/ubun= tu/

This makes your OS upgrades and the PostgreSQL updates more independent of each other. Plus, you always can get the latest PostgreSQL version, while the distribution repositories only offer the current version as of its publishing. So, Ubuntu 20.04 only has the 2019 version of PostgreSQL.

--=20

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------3P9OQMXJ5LNY4uiVP1Lr0Pog-- --------------foLR0loq50G13MiVDGjLUuBg-- --------------zyBlp5MRCkdzxFImSNLu0U55 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYYrM3gUDAAAAAAAKCRCKV5yTsxlhulPP AKCTONxBSyORP1uf+sX1qVyW0OhGwwCeL+uhES+oMqQeXIQ+PFTbltxQBEk= =q7xq -----END PGP SIGNATURE----- --------------zyBlp5MRCkdzxFImSNLu0U55--