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

[Brian Murray]

I tested an upgrade from cosmic to disco with postgresql-10 installed
and received a message, attached in a screenshot, regarding the
transition from postgresql-10 to postgresql-11. Did you receive that
message?

** Attachment added: "bug-1825563-postgresql-prompt.png"
   https://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+bug/1825563/+attachment/5257124/+files/bug-1825563-postgresql-prompt.png

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