Hello, thanks for filing this bug in Ubuntu.

I just tried a release upgrade from Cosmic to Disco.

Beforehand, I installed "postgresql" and its dependencies on Cosmic. I
got the server postgresql-10 at version 10.7.

Cluster was online:

root@cosmic-pgsql10:~# pg_lsclusters 
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5432 online postgres /var/lib/postgresql/10/main 
/var/log/postgresql/postgresql-10-main.log

I then issued a do-release-upgrade.

During the upgrade, I got a warning that postgresql 10 is an "obsolete
major version", and it told me postgresql 11 was going to be installed,
and how I could migrate from to the other. I just acknowledged it, and
the upgrade continued.

In the end, the process told me some packages were going to be removed.
I opted to see a list, and there were no postgresql packages in there,
so I gave it an OK to continue.

The upgrade finished, and before rebooting, I got a postgresql package list to 
see what was installed:
root@cosmic-pgsql10:~# dpkg -l|grep postgresql
ii  postgresql                     11+199                            all        
  object-relational SQL database (supported version)
ii  postgresql-10                  10.7-0ubuntu0.18.10.1             amd64      
  object-relational SQL database, version 10 server
ii  postgresql-11                  11.2-1                            amd64      
  object-relational SQL database, version 11 server
ii  postgresql-client-10           10.7-0ubuntu0.18.10.1             amd64      
  front-end programs for PostgreSQL 10
ii  postgresql-client-11           11.2-1                            amd64      
  front-end programs for PostgreSQL 11
ii  postgresql-client-common       199                               all        
  manager for multiple PostgreSQL client versions
ii  postgresql-common              199                               all        
  PostgreSQL database-cluster manager

As can be seen, I have both postgresql 10 and 11 co-installed, and both 
clusters are running:
root@cosmic-pgsql10:~# pg_lsclusters 
Ver Cluster Port Status Owner    Data directory              Log file
10  main    5432 online postgres /var/lib/postgresql/10/main 
/var/log/postgresql/postgresql-10-main.log
11  main    5433 online postgres /var/lib/postgresql/11/main 
/var/log/postgresql/postgresql-11-main.log


Could you please elaborate on how you performed your testing, which packages 
you had installed before and after, and also please attach the upgrade logs 
from /var/log/dist-upgrade?

I'll mark the bug as incomplete for now. Please feel free to switch it
back to "new" after you provide the requested information.


** Changed in: postgresql-11 (Ubuntu)
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1825501

Title:
  Upgrading the distro PURGED the previous postgresql-10 package
  deleting the database data!

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-11/+bug/1825501/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to