AW: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.

Hi,

maybe a force install does the trick.

apt-get -f install

I know normally this is for unresolved dependencies but its worth a try.

Also see: https://askubuntu.com/questions/140247/force-install-apt-get

Yes i would try to remove the offending package postgresql-12-postgis-3, but make shure you can restore: snapshot or verified backup.

best,

A

Von: Holger Jakobs <holger(at)jakobs(dot)com>
Gesendet: Dienstag, 9. November 2021 20:33
An: pgsql-admin(at)lists(dot)postgresql(dot)org
Betreff: Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist. [signed INVALID]

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. Currently 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. 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-.*[0-9][0-9].*' matches 'postgresql-12-postgis-3'

2021-11-09 08:35:50,044 DEBUG The package 'postgresql-12-postgis-3' is marked for removal but it's in the removal blacklist

2021-11-09 08:35:50,053 ERROR Dist-upgrade failed: 'The package 'postgresql-12-postgis-3' is marked for removal but it is in the removal blacklist.'

2021-11-09 08:35:50,055 DEBUG abort called

The offending package 'postgresql-12-postgis-3' corresponds my current Postgresql version. Should I remove the package and proceed with OS upgrade? I am at a loss...

What repository did you install it from?

--
Angular momentum makes the world go 'round.

--

Regards,

Bo Guo, PhD, PE

President

Gistic Research, Inc.

2033 E Warner Rd Ste 105

Tempe, AZ 85284

www.gisticinc.com<http://www.gisticinc.com>

www.youtube.com/linearbench<http://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/ubuntu/

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.

--

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012