Subject: Re: Ubuntu Upgrade from 18.04 to 20.04 failed due to Postgres/Postgis
 package on removal blacklist.
To: pgsql-admin@lists.postgresql.org
References: 
 <CAK_Ha4zXQYnBbsvtpWeU234dGV=rtvi5ALkk_eS_KQ_sMiD7=Q@mail.gmail.com>
 <CAM+6J95DU-tow6K1JWb5UGmdcwYHP5z=7_XzijzAaEHnNPBftQ@mail.gmail.com>
 <28768e4f-f6f7-ad78-d0dc-169954a06156@gisticinc.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com>
Date: Tue, 9 Nov 2021 11:16:24 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <28768e4f-f6f7-ad78-d0dc-169954a06156@gisticinc.com>
Content-Type: multipart/alternative;
 boundary="------------2D72174DC03C10D63B68EB25"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/8b2140bd-cfc8-aa5b-d120-e4fa44710135%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------2D72174DC03C10D63B68EB25
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.

--------------2D72174DC03C10D63B68EB25
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 11/9/21 10:23 AM, Bo Guo wrote:<br>
    <blockquote type="cite"
      cite="mid:28768e4f-f6f7-ad78-d0dc-169954a06156@gisticinc.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <p>Hello Community!</p>
      <p>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 .</p>
      <p>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:<br>
      </p>
      <pre>2021-11-09 08:35:50,044 DEBUG blacklist expr '^postgresql-.*[0-9][0-9].*' matches 'postgresql-12-postgis-3'</pre>
      <pre>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</pre>
      <pre>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.'</pre>
      <pre>2021-11-09 08:35:50,055 DEBUG abort called</pre>
      <p>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...  <br>
      </p>
    </blockquote>
    <br>
    What repository did you install it from?  <br>
    <br>
    -- <br>
    <div class="moz-signature">Angular momentum makes the world go
      'round.</div>
  </body>
</html>

--------------2D72174DC03C10D63B68EB25--