Upgrade icinga2 and its web-interface using official/dedicated repository and PostgreSQL database.

Remember about backups.

Update package index.

$ sudo apt-get update

I will upgrade icinga2 from version 2.7.1-2 to 2.8.0-1.

$ apt-cache policy icinga2-ido-pgsql
icinga2-ido-pgsql:
  Installed: 2.7.1-2.stretch
  Candidate: 2.8.0-1.stretch
  Version table:
     2.8.0-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
     2.7.2-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
 *** 2.7.1-2.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
        100 /var/lib/dpkg/status
     2.7.1-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
     2.7.0-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
     2.6.3-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
     2.6.0-2 500
        500 http://ftp.task.gda.pl/debian stretch/main amd64 Packages

I will upgrade icingaweb2 from version 2.4.2-1 to 2.5.0-1.

$ apt-cache policy icingaweb2
icingaweb2:
  Installed: 2.4.2-1.stretch
  Candidate: 2.5.0-1.stretch
  Version table:
     2.5.0-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
 *** 2.4.2-1.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
        100 /var/lib/dpkg/status
     2.4.1-2.stretch 500
        500 http://packages.icinga.com/debian icinga-stretch/main amd64 Packages
     2.4.1-1 500
        500 http://ftp.task.gda.pl/debian stretch/main amd64 Packages

Upgrade these packages.

$ sudo apt-get upgrade -o Dpkg::Options::="--force-confold" -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
  linux-image-amd64
The following packages will be upgraded:
  icinga2 icinga2-bin icinga2-common icinga2-doc icinga2-ido-pgsql icingacli icingaweb2 icingaweb2-common icingaweb2-module-doc icingaweb2-module-monitoring libicinga2 php-icinga
12 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 9,448 kB of archives.
After this operation, 1,080 kB of additional disk space will be used.
Get:1 http://packages.icinga.com/debian icinga-stretch/main amd64 icinga2-ido-pgsql amd64 2.8.0-1.stretch [179 kB]
Get:2 http://packages.icinga.com/debian icinga-stretch/main amd64 icinga2 amd64 2.8.0-1.stretch [83.3 kB]
Get:3 http://packages.icinga.com/debian icinga-stretch/main amd64 icinga2-bin amd64 2.8.0-1.stretch [152 kB]
Get:4 http://packages.icinga.com/debian icinga-stretch/main amd64 libicinga2 amd64 2.8.0-1.stretch [2,405 kB]
Get:5 http://packages.icinga.com/debian icinga-stretch/main amd64 icinga2-common all 2.8.0-1.stretch [128 kB]
Get:6 http://packages.icinga.com/debian icinga-stretch/main amd64 icinga2-doc all 2.8.0-1.stretch [1,502 kB]
Get:7 http://packages.icinga.com/debian icinga-stretch/main amd64 icingaweb2-module-monitoring all 2.5.0-1.stretch [666 kB]
Get:8 http://packages.icinga.com/debian icinga-stretch/main amd64 icingaweb2-module-doc all 2.5.0-1.stretch [42.0 kB]
Get:9 http://packages.icinga.com/debian icinga-stretch/main amd64 icingaweb2-common all 2.5.0-1.stretch [365 kB]
Get:10 http://packages.icinga.com/debian icinga-stretch/main amd64 icingacli all 2.5.0-1.stretch [26.6 kB]
Get:11 http://packages.icinga.com/debian icinga-stretch/main amd64 icingaweb2 all 2.5.0-1.stretch [3,149 kB]
Get:12 http://packages.icinga.com/debian icinga-stretch/main amd64 php-icinga all 2.5.0-1.stretch [750 kB]
Fetched 9,448 kB in 1s (5,861 kB/s)
apt-listchanges: Reading changelogs...
Preconfiguring packages ...
(Reading database ... 42122 files and directories currently installed.)
Preparing to unpack .../00-icinga2-ido-pgsql_2.8.0-1.stretch_amd64.deb ...
Unpacking icinga2-ido-pgsql (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
Preparing to unpack .../01-icinga2_2.8.0-1.stretch_amd64.deb ...
Unpacking icinga2 (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
Preparing to unpack .../02-icinga2-bin_2.8.0-1.stretch_amd64.deb ...
Unpacking icinga2-bin (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
Preparing to unpack .../03-libicinga2_2.8.0-1.stretch_amd64.deb ...
Unpacking libicinga2 (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
Preparing to unpack .../04-icinga2-common_2.8.0-1.stretch_all.deb ...
Unpacking icinga2-common (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
dpkg: warning: unable to delete old directory '/etc/icinga2/repository.d': Directory not empty
Preparing to unpack .../05-icinga2-doc_2.8.0-1.stretch_all.deb ...
Unpacking icinga2-doc (2.8.0-1.stretch) over (2.7.1-2.stretch) ...
Preparing to unpack .../06-icingaweb2-module-monitoring_2.5.0-1.stretch_all.deb ...
Unpacking icingaweb2-module-monitoring (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Preparing to unpack .../07-icingaweb2-module-doc_2.5.0-1.stretch_all.deb ...
Unpacking icingaweb2-module-doc (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Preparing to unpack .../08-icingaweb2-common_2.5.0-1.stretch_all.deb ...
Unpacking icingaweb2-common (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Preparing to unpack .../09-icingacli_2.5.0-1.stretch_all.deb ...
Unpacking icingacli (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Preparing to unpack .../10-icingaweb2_2.5.0-1.stretch_all.deb ...
Unpacking icingaweb2 (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Preparing to unpack .../11-php-icinga_2.5.0-1.stretch_all.deb ...
Unpacking php-icinga (2.5.0-1.stretch) over (2.4.2-1.stretch) ...
Setting up icinga2-common (2.8.0-1.stretch) ...
Installing new version of config file /etc/icinga2/conf.d/timeperiods.conf ...

Configuration file '/etc/icinga2/features-available/api.conf'
 ==> Modified (by you or by a script) since installation.
 ==> Package distributor has shipped an updated version.
 ==> Using current old file as you requested.
Installing new version of config file /etc/icinga2/icinga2.conf ...
Setting up libicinga2 (2.8.0-1.stretch) ...
Setting up icinga2-bin (2.8.0-1.stretch) ...
Setting up icinga2 (2.8.0-1.stretch) ...
Setting up php-icinga (2.5.0-1.stretch) ...
Processing triggers for systemd (232-25+deb9u1) ...
Setting up icingacli (2.5.0-1.stretch) ...
Setting up icingaweb2-common (2.5.0-1.stretch) ...
Processing triggers for man-db (2.7.6.1-2) ...
Setting up icingaweb2 (2.5.0-1.stretch) ...
Setting up icinga2-ido-pgsql (2.8.0-1.stretch) ...
dbconfig-common: writing config to /etc/dbconfig-common/icinga2-ido-pgsql.conf
dbconfig-common: flushing administrative password
Setting up icinga2-doc (2.8.0-1.stretch) ...
Setting up icingaweb2-module-doc (2.5.0-1.stretch) ...
Setting up icingaweb2-module-monitoring (2.5.0-1.stretch) ...

icinga2 daemon will not work due to database schema change.

$ sudo tail /var/log/icinga2/icinga2.log
[2017-12-21 12:00:12 -0600] warning/IdoPgsqlConnection: Exception during database operation: Verify that your database is operational!                                                                             
[2017-12-21 12:00:22 -0600] critical/IdoPgsqlConnection: Schema version '1.14.2' does not match the required version '1.14.3' (or newer)! Please check the upgrade documentation at https://docs.icinga.com/icinga2
/latest/doc/module/icinga2/chapter/upgrading-icinga-2#upgrading-postgresql-db                                                                                                                                      
Context:                                                                                                                                                                                                           
        (0) Reconnecting to PostgreSQL IDO database 'ido-pgsql'     

Inspect the number of database upgrades you need to perform for icinga2.

There is only one this time.

$ ls /usr/share/icinga2-ido-pgsql/schema/upgrade/
2.0.2.sql  2.1.0.sql  2.2.0.sql  2.3.0.sql  2.4.0.sql  2.5.0.sql  2.6.0.sql  2.8.0.sql

Display database configuration.

$ sudo cat /etc/icinga2/features-enabled/ido-pgsql.conf
/**
 * The db_ido_pgsql library implements IDO functionality
 * for PostgreSQL.
 */

library "db_ido_pgsql"

object IdoPgsqlConnection "ido-pgsql" {
  user = "icinga_ido",
  password = "icinga_ido_pwd",
  host = "localhost",
  database = "icinga_ido"
}

Upgrade database.

$ PGHOST="localhost" PGUSER="icinga_ido" PGPASSWORD="icinga_ido_pwd" PGDATABASE="icinga_ido" \
  psql < /usr/share/icinga2-ido-pgsql/schema/upgrade/2.8.0.sql
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
 updatedbversion 
-----------------
 
(1 row)

Inspect the number of database upgrades you need to perform for icingaweb2.

There is only one this time.

$ ls /usr/share/icingaweb2/etc/schema/pgsql-upgrades/
2.0.0beta3-2.0.0rc1.sql  2.5.0.sql

Display database configuration.

$ sudo cat /etc/icingaweb2/resources.ini
[icingaweb_db]
type = "db"
db = "pgsql"
host = "localhost"
port = "5432"
dbname = "icinga_web"
username = "icinga_web"
password = "icinga_web_pwd"
charset = "UTF-8"
persistent = "0"

[...]

Upgrade database.

$ PGHOST="localhost" PGUSER="icinga_web" PGPASSWORD="icinga_web_pwd" PGDATABASE="icinga_web" \
  psql < /usr/share/icingaweb2/etc/schema/pgsql-upgrades/2.5.0.sql
ALTER TABLE
ALTER TABLE
ALTER TABLE

icinga2 daemon should be operational at this moment.

Read Upgrading Icinga 2 and Upgrading Icinga Web 2 documents to perform additional steps.

ko-fi