[Pkg-nagios-devel] Bug#675536: Bug#675536: icinga-idoutils: fails to upgrade from squeeze: ERROR: language "plpgsql" does not exist

[Alexander Wirt]

On Sat, 02 Jun 2012, Andreas Beckmann wrote:

> Package: icinga-idoutils
> Version: 1.7.0-2
> Severity: serious
> User: debian-qa at lists.debian.org
> Usertags: piuparts
> 
> Hi,
> 
> during a test with piuparts I noticed your package fails to upgrade from
> 'squeeze'.
> It installed fine in 'squeeze', then the upgrade to 'sid' fails.
> 
> >From the attached log (scroll to the bottom...):
> 
>   Setting up icinga-idoutils (1.7.0-2) ...
>   Installing new version of config file /etc/init.d/ido2db ...
>   Installing new version of config file /etc/icinga/idomod.cfg ...
>   dbconfig-common: writing config to /etc/dbconfig-common/icinga-idoutils.conf
>   Replacing config file /etc/icinga/ido2db.cfg with new version
>   creating database backup in /var/cache/dbconfig-common/backups/icinga-idoutils_1.0.2-2.pgsql.
>   applying upgrade sql for 1.0.2-2 -> 1.0.3-1.
>   applying upgrade sql for 1.0.2-2 -> 1.2.99-1.
>   error encountered processing /usr/share/dbconfig-common/data/icinga-idoutils/upgrade/pgsql/1.2.99-1:
>   NOTICE: ALTER TABLE will create implicit sequence "icinga_dbversion_dbversion_id_seq" for serial column "icinga_dbversion.dbversion_id" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "icinga_dbversion_pkey" for table "icinga_dbversion" ERROR: language "plpgsql" does not exist HINT: Use CREATE LANGUAGE to load the language into the database.
>   dbconfig-common: icinga-idoutils configure: aborted.
>   dbconfig-common: flushing administrative password
>   dpkg: error processing icinga-idoutils (--configure):
>    subprocess installed post-installation script returned error exit status 1
hu? I tested that and I installed plpgsql via adminstrative script, I'll have
to take a look. Btw. 9.1 (the supported postgres version from wheezy doesn't
need to instal plpgsql).

Alex