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>
From: Bo Guo <bo.guo@gisticinc.com>
Message-ID: <50aa5f0c-589e-a3d0-2979-f57c0de7d7ca@gisticinc.com>
Date: Tue, 9 Nov 2021 10:50:29 -0700
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: <8b2140bd-cfc8-aa5b-d120-e4fa44710135@gmail.com>
Content-Type: multipart/alternative;
 boundary="------------31AFC26B975DC887022159B3"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/50aa5f0c-589e-a3d0-2979-f57c0de7d7ca%40gisticinc.com>
Precedence: bulk

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

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


--------------31AFC26B975DC887022159B3
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>
    <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">www.gisticinc.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.youtube.com/linearbench">www.youtube.com/linearbench</a>
Office: 480-656-9962
Cell: 602-570-4697</pre>
  </body>
</html>

--------------31AFC26B975DC887022159B3--