Public bug reported: The packet postgresql-plperl (and probably other addon packages for postgresql) blocks do-release-upgrade from 16.04LTS to 18.04LTS.
This requiresthen requires a complete dump-and-restore cycle: 1) Stop user applications 2) do a full database export 3) stop postgresql 4) uninstall postgresql and all subpackages 5) delete remaining tablespace directories 6) do-release-upgrade 7) reinstall postgresql and the required subpackages 8) restore database from backup 9) start user applications This requires a much longer downtime than just using pg_upgradecluster, because the database is offline during the whole do-release-upgrade cycle. ** Affects: ubuntu-meta (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to ubuntu-meta in Ubuntu. https://bugs.launchpad.net/bugs/1787349 Title: postgresql-plperl-9.5 blocks do-release-upgrade from 16.04 to 18.04 Status in ubuntu-meta package in Ubuntu: New Bug description: The packet postgresql-plperl (and probably other addon packages for postgresql) blocks do-release-upgrade from 16.04LTS to 18.04LTS. This requiresthen requires a complete dump-and-restore cycle: 1) Stop user applications 2) do a full database export 3) stop postgresql 4) uninstall postgresql and all subpackages 5) delete remaining tablespace directories 6) do-release-upgrade 7) reinstall postgresql and the required subpackages 8) restore database from backup 9) start user applications This requires a much longer downtime than just using pg_upgradecluster, because the database is offline during the whole do-release-upgrade cycle. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/ubuntu-meta/+bug/1787349/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp