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

Reply via email to