[Bug 2139618] Re: 24.04 LTS won't install due to PostgreSQL 15

[Richard K]

I found a "work around" thanks to Gemini.

# Add the Official PostgreSQL Repo
# By adding the official repo, the upgrader will see that `postgresql-15` is available for **both** Jammy (24.04) and Noble (24.04). This usually clears the "unresolvable problem" because it no longer has to choose between "delete it" or "break dependencies."

# A. **Add the repository key and source:**
sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

# B. Update your package lists:
sudo apt update

# C. Try the "Dry Run" Upgrade
#    Instead of the full GUI or release-upgrade immediately, run this to see exactly what is breaking:
sudo apt dist-upgrade
# Note: If it completes: Great! Now run `sudo do-release-upgrade`.

# D. Run Upgrade:
sudo do-release-upgrade

# E. Re-enable and Update the Repository
#    The upgrade process usually comments out the lines in your source files. We need to point them to the new version of Ubuntu.
#    Run the following to automatically refresh the PostgreSQL repo for 24.04:
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

# F. Verify Version 15 is Active
#   Check the status of your database cluster. This command is the "gold standard" for seeing which versions are running and on which ports:
pg_lsclusters

I'm now working through all the stuff the upgrade broke.
I had to re-install vim.
I'm trying to get my desktop "launchers" to not show ".desktop"
Get the desktop "launchers" so the icons show again.
And figure out how to get pgadmin4 back (their problem not yours as for some reason they don't support LTS releases).

-- 
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/2139618

Title:
  24.04 LTS won't install due to PostgreSQL 15

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

Bug description:
  When trying to upgrade from xUbuntu 22.04 LTS to 24.04 LTS I get this
  error:

  The package 'postgresql-15' is marked for removal but it is in the 
  removal deny list. 

  To prevent data loss, postgresql packages are not removed 
  automatically during the upgrade. If you are certain you no longer 
  need postgresql-15, you can manually remove it and try the upgrade 
  again. 

  If none of this applies, then please report this bug using the 
  command 'ubuntu-bug ubuntu-release-upgrader-core' in a terminal. If 
  you want to investigate this yourself the log files in 
  '/var/log/dist-upgrade' will contain details about the upgrade. 
  Specifically, look at 'main.log' and 'apt.log'. 


  However I need to stay on PostgreSQL 15 due to that is what we are
  using. I need to get past this error and keep postgresql-15 on my
  system until such time as we plan an upgrade.

  Thank you,
  Richard Knechtel

  ProblemType: Bug
  DistroRelease: Ubuntu 22.04
  Package: ubuntu-release-upgrader-core 1:22.04.20
  ProcVersionSignature: Ubuntu 6.8.0-94.96~22.04.1-generic 6.8.12
  Uname: Linux 6.8.0-94-generic x86_64
  ApportVersion: 2.20.11-0ubuntu82.10
  Architecture: amd64
  CasperMD5CheckResult: unknown
  CrashDB: ubuntu
  CrashReports:
   640:1000:127:181100:2026-02-02 10:23:39.944026717 -0600:2026-02-02 10:23:39.963017217 -0600:/var/crash/_opt_VBoxGuestAdditions-7.0.20_bin_VBoxClient.1000.crash
   644:1000:127:0:2026-02-02 10:23:39.944026717 -0600:2026-02-02 10:23:39.944026717 -0600:/var/crash/_opt_VBoxGuestAdditions-7.0.20_bin_VBoxClient.1000.upload
   600:120:127:5:2026-02-02 10:23:40.815590716 -0600:2026-02-02 10:23:40.815590716 -0600:/var/crash/_opt_VBoxGuestAdditions-7.0.20_bin_VBoxClient.1000.uploaded
  CurrentDesktop: XFCE
  Date: Mon Feb  2 11:33:28 2026
  InstallationDate: Installed on 2021-08-27 (1620 days ago)
  InstallationMedia: Xubuntu 20.04.2.0 LTS "Focal Fossa" - Release amd64 (20210209.1)
  PackageArchitecture: all
  SourcePackage: ubuntu-release-upgrader
  UpgradeStatus: Upgraded to jammy on 2026-02-02 (0 days ago)
  VarLogDistupgradeAptHistorylog:
   Start-Date: 2026-02-02  11:32:31
   Requested-By: rknechtel (1000)
   End-Date: 2026-02-02  11:32:31
  VarLogDistupgradeApttermlog:
   Log started: 2026-02-02  11:32:31
   Log ended: 2026-02-02  11:32:31

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