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

[Brian Murray]

Thanks for taking the time to report this bug and I hope the databases
aren't really gone. Are the databases still in /var/lib/postgresql?
Could you provide the /var/log/dist-upgrade/apt-term.log file for the
upgrade so we can understand why the packages were removed?

** Changed in: ubuntu-release-upgrader (Ubuntu)
   Importance: Undecided => High

** Changed in: ubuntu-release-upgrader (Ubuntu)
       Status: New => Incomplete

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