[Bug 1825563] Re: automatically removed packages includes postgresql-10 which can result in cluster dropping

[Launchpad Bug Tracker]

This bug was fixed in the package ubuntu-release-upgrader - 1:19.10.1

---------------
ubuntu-release-upgrader (1:19.10.1) eoan; urgency=medium

  * DistUpgrade/{EOL,Devel}ReleaseAnnouncement,
    DistUpgrade/window_main.ui,
    data/gtkbuilder/DistUpgrade.ui,
    data/DistUpgrade.cfg,
    pre-build.sh:
    - updated for 19.04 -> 19.10
  * data/DistUpgrade.cfg.bionic,
    data/demoted.cfg.bionic,
    pre-build.sh:
    - support upgrades from bionic (LP: #1827635)
  * data/removal_blacklist.cfg: add blacklist entry for postgresql versions
    with two major digits e.g. postgresql-11. (LP: #1825563)
  * Fix broken symbolic link of DistUpgrade/DistUpgrade which caused code from
    the installed ubuntu-release-upgrader to be used instead of code in the
    dist-upgrader tarball. (LP: #1824430)

 -- Brian Murray <brian at ubuntu.com>  Fri, 03 May 2019 10:24:48 -0700

** Changed in: ubuntu-release-upgrader (Ubuntu)
       Status: In Progress => Fix Released

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

Title:
  automatically removed packages includes postgresql-10 which can result
  in cluster dropping

Status in ubuntu-release-upgrader package in Ubuntu:
  Fix Released
Status in ubuntu-release-upgrader source package in Disco:
  Fix Released

Bug description:
  [Impact]
  Users who choose to autoremove packages can have postgresql-10 removed which during its purge will drop the cluster and its databases.

  [Test Case]
  On a cosmic system
  1) install postgresql-10 and ubuntu-release-upgrader-core
  2) create a test database using psql - create database junk;
  3) fill that database with junk using pgbench e.g. pgbench -in -s10 junk
  4) verify you have data in /var/lib/postgresql - du -sh /var/lib/postgresql/*
  5) run do-release-upgrade
  6) choose to automatically remove packages (watch postgresql-10 get removed)
  7) observe you have no more data in /var/lib/postgresql

  With the version of the release upgrader in -proposed postgresql-10
  will not be removed, postgresql-11 will not be installed and you'll
  still have your data.

  [Regression Potential]
  The regex could be too generic and prevent some other packages from being removed so look at it closely.

  While upgrading to Ubuntu 19.04, the release upgrader removed
  postgresql-10. To make matters worse, apt/dpkg did NOT ask whether the
  databases should be kept and simply removed all of them.

  I believe this is due to removal_blacklist.cfg containing
  ^postgresql-.*[0-9]\.[0-9].*, which does not match newer releases such
  as postgresql-10 as it expects an X.Y version scheme. Something like
  ^postgresql-.*[0-9].* should probably be added in addition.

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