[Pkg-postgresql-public] Bug#703850: postgresql-contrib not upgraded

[Daniel Pocock]

Package: postgresql-9.1
Version:
Severity: serious


This is an upgrade problem

Old system has postgresql-8.4 and postgresql-contrib-8.4 on squeeze

It is upgraded to wheezy

postgressql-9.1 was installed, but postgresql-contrib-9.1 doesn't get
installed by the dist-upgrade

Unaware of the fact postgresql-contrib-9.1 is missing, I ran

  pg_upgradecluster 8.4 main

to upgrade my database

Lots of errors such as:

Configuring postgresql.conf to use port 5433...
Disabling connections to the new cluster during upgrade...
Roles, databases, schemas, ACLs...
ERROR:  could not access file "$libdir/pgcrypto": No such file or directory
ERROR:  function public.armor(bytea) does not exist
ERROR:  could not access file "$libdir/pgcrypto": No such file or directory
ERROR:  function public.crypt(text, text) does not exist
ERROR:  could not access file "$libdir/pgcrypto": No such file or directory
ERROR:  function public.dearmor(text) does not exist
ERROR:  could not access file "$libdir/pgcrypto": No such file or directory
ERROR:  function public.decrypt(bytea, bytea, text) does not exist


Fortunately this was trust a trial run