[Bug 1825563] Re: Upgrade to Ubuntu 19.04 removed PostgreSQL databases

[Michael Kuhn]

Sadly, the databases were indeed gone. do-release-upgrade purged the
postgresql-10 package, which dropped the cluster. I have a backup from
last night, so I could restore a fairly recent state.

I have attached the relevant part of apt-term.log (the rest of the file
contained config file diffs with passwords etc.); if you need anything
else, please let me know. postgresql-10 was removed during the last step
of do-release-upgrade (removing automatically installed packages).

I cannot remember a dialog such as the one shown in your screenshot.
Should the prompt be recorded in apt-term.log? If so, I guess it did not
pop up since I cannot find anything similar in there.

** Attachment added: "apt-term.log"
   https://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+bug/1825563/+attachment/5257125/+files/apt-term.log

-- 
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:
  Upgrade to Ubuntu 19.04 removed PostgreSQL databases

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

Bug description:
  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