[Bug 2078745] Re: Unable to upgrade to 24.04 due to error: "The package 'postgresql-14-postgis-3' is marked for removal but it is in the removal deny list."

[Ubfan]

Must have found something wrong with the old approach of not touching
the running (old) postgresql, installing the new db (empty) listening on
the next port (typically 5433), and letting the user dump the old, load
the new, run/test in parallel until satisfied the new one works, and
remove the old, and change the listening port to the preferred (5432
default). Caution is best when fiddling with databases.

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to ubuntu-release-upgrader in
Ubuntu.
https://bugs.launchpad.net/bugs/2078745

Title:
  Unable to upgrade to 24.04 due to error: "The package
  'postgresql-14-postgis-3' is marked for removal but it is in the
  removal deny list."

Status in ubuntu-release-upgrader package in Ubuntu:
  Invalid

Bug description:
  I received a notification that Ubuntu 24.04.1 was finally available
  and I could now upgrade to it. I started the upgrade process but it
  stopped due to the aforementioned error stating: "The package
  'postgresql-14-postgis-3' is marked for removal but it is in the
  removal deny list."

  The error message also suggested that I report the issue using the
  "ubuntu-bug ubuntu-release-upgrader-core" command, so here we are.

  I do have Postgres and PostGIS installed locally, with lots of useful
  data in it. How can I upgrade smoothly without data loss? Or do I have
  to back it up, uninstall Postgres and restore from the backup?

  ProblemType: Bug
  DistroRelease: Ubuntu 22.04
  Package: ubuntu-release-upgrader-core 1:22.04.19
  ProcVersionSignature: Ubuntu 6.8.0-40.40~22.04.3-generic 6.8.12
  Uname: Linux 6.8.0-40-generic x86_64
  ApportVersion: 2.20.11-0ubuntu82.6
  Architecture: amd64
  CasperMD5CheckResult: pass
  CrashDB: ubuntu
  CurrentDesktop: ubuntu:GNOME
  Date: Mon Sep  2 23:05:04 2024
  InstallationDate: Installed on 2024-04-20 (135 days ago)
  InstallationMedia: Ubuntu 22.04.1 LTS "Jammy Jellyfish" - Release amd64 (20220809.1)
  PackageArchitecture: all
  ProcEnviron:
   TERM=xterm-256color
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: ubuntu-release-upgrader
  UpgradeStatus: Upgraded to jammy on 2024-09-02 (0 days ago)
  VarLogDistupgradeAptHistorylog:
   Start-Date: 2024-09-02  22:54:20
   Requested-By: yewo (1000)
   End-Date: 2024-09-02  22:54:20
  VarLogDistupgradeApttermlog:
   Log started: 2024-09-02  22:54:20
   Log ended: 2024-09-02  22:54:20
  VarLogDistupgradeTermlog:

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+bug/2078745/+subscriptions