postgresql-plperl-9.5 blocks do-release-upgrade from 16.04 to 18.04

Bug #1787349 reported by Rene Schickbauer
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
ubuntu-release-upgrader (Ubuntu)
New
Undecided
Unassigned

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.

Tags: bionic cosmic
affects: ubuntu-meta (Ubuntu) → ubuntu-release-upgrader (Ubuntu)
tags: added: bionic cosmic
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.