pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUbuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
5+ messages / 3 participants
[nested] [flat]
* Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
@ 2021-11-09 16:23 Bo Guo <bo.guo@gisticinc.com>
0 siblings, 1 reply; 5+ messages in thread
From: Bo Guo @ 2021-11-09 16:23 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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...
Thanks!
Bo
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
@ 2021-11-09 17:16 Ron <ronljohnsonjr@gmail.com>
parent: Bo Guo <bo.guo@gisticinc.com>
0 siblings, 1 reply; 5+ messages in thread
From: Ron @ 2021-11-09 17:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
@ 2021-11-09 17:50 Bo Guo <bo.guo@gisticinc.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Bo Guo @ 2021-11-09 17:50 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
www.youtube.com/linearbench
Office: 480-656-9962
Cell: 602-570-4697
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
@ 2021-11-09 19:26 Ron <ronljohnsonjr@gmail.com>
parent: Bo Guo <bo.guo@gisticinc.com>
1 sibling, 0 replies; 5+ messages in thread
From: Ron @ 2021-11-09 19:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
The "it" is postgresql-12-postgis-3, since that's what you're having trouble
with.
On 11/9/21 11:50 AM, Bo Guo wrote:
>
> 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
> www.youtube.com/linearbench
> Office: 480-656-9962
> Cell: 602-570-4697
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist.
@ 2021-11-09 19:32 Holger Jakobs <holger@jakobs.com>
parent: Bo Guo <bo.guo@gisticinc.com>
1 sibling, 0 replies; 5+ messages in thread
From: Holger Jakobs @ 2021-11-09 19:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
> 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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-11-09 19:32 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-09 16:23 Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis package on removal blacklist. Bo Guo <bo.guo@gisticinc.com>
2021-11-09 17:16 ` Ron <ronljohnsonjr@gmail.com>
2021-11-09 17:50 ` Bo Guo <bo.guo@gisticinc.com>
2021-11-09 19:26 ` Ron <ronljohnsonjr@gmail.com>
2021-11-09 19:32 ` Holger Jakobs <holger@jakobs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox