automatically removed packages includes postgresql-10 which can result in cluster dropping
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
ubuntu-release-upgrader (Ubuntu) |
Fix Released
|
High
|
Brian Murray | ||
Disco |
Fix Released
|
Undecided
|
Unassigned |
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-
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/
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_
Changed in ubuntu-release-upgrader (Ubuntu): | |
status: | Incomplete → In Progress |
summary: |
- Upgrade to Ubuntu 19.04 removed PostgreSQL databases + automatically removed packages includes postgresql-10 which can result + in cluster dropping |
Changed in ubuntu-release-upgrader (Ubuntu): | |
assignee: | nobody → Brian Murray (brian-murray) |
description: | updated |
tags: | added: disco eoan |
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?