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>
 <8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com>
 <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <bae50f49-434c-daba-21aa-ad6b3b1c1b6f@gmail.com>
Date: Tue, 9 Nov 2021 13:26:52 -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: <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com>
Content-Type: multipart/alternative;
 boundary="------------4505AFA0175BF93881FEAB5B"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/bae50f49-434c-daba-21aa-ad6b3b1c1b6f%40gmail.com>
Precedence: bulk

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

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.

--------------4505AFA0175BF93881FEAB5B
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>
    The "it" is postgresql-12-postgis-3, since that's what you're having
    trouble with.<br>
    <br>
    <div class="moz-cite-prefix">On 11/9/21 11:50 AM, Bo Guo wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <p>Ron,</p>
      <p>Ubuntu release upgrade (do-release-upgrade) uses Ubuntu
        official repository, I believe.</p>
      <p>Bo<br>
      </p>
      <div class="moz-cite-prefix">On 11/9/21 10:16 AM, Ron wrote:<br>
      </div>
      <blockquote type="cite"
        cite="mid:8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com">
        <meta http-equiv="Content-Type" content="text/html;
          charset=UTF-8">
        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>
      </blockquote>
      <pre class="moz-signature" cols="72">-- 
Regards,

Bo Guo, PhD, PE
President
Gistic Research, Inc.
2033 E Warner Rd Ste 105
Tempe, AZ 85284
<a class="moz-txt-link-abbreviated" href="http://www.gisticinc.com" moz-do-not-send="true">www.gisticinc.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.youtube.com/linearbench" moz-do-not-send="true">www.youtube.com/linearbench</a>
Office: 480-656-9962
Cell: 602-570-4697</pre>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------4505AFA0175BF93881FEAB5B--