Problem: Upgrade Fails With An Error Related To PostgreSQL

postgresql
upgrade
problem

#1

Problem: Upgrade Fails With An Error Related To PostgreSQL

You attempted to perform an upgrade which fails. In /var/log/univention/updater.log you will notice the following errors:

Errors were encountered while processing:
 postgresql-common
 postgresql-9.1
 postgresql-server-dev-9.1
E: Sub-process /usr/bin/dpkg returned an error code (1)

Trying to fix the package database results the following error:

root@ucs:~# dpkg --configure -a
postgresql-common (165+deb8u2A~4.2.0.201703021601) wird eingerichtet ...
[....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2019-05-10 17:12:39 CEST
LOG: could not open configuration file "/etc/p[FAILesql/9.1/main/pg_hba.conf":
No such file or directory 2019-05-10 17:12:39 CEST FATAL: could not load pg_hba.conf ... failed!
failed!

[...]

dpkg: Fehler beim Bearbeiten des Paketes postgresql-server-dev-9.1 (--configure):
Abhängigkeitsprobleme - verbleibt unkonfiguriert
Fehler traten auf beim Bearbeiten von:
postgresql-common
postgresql-9.1
postgresql-server-dev-9.1

Investigation

This might be a left-over from an earlier app which has been removed a while ago.
Make sure there are no databases configured in PostgreSQL:

root@ucs:~# ls -alh /etc/postgresql
insgesamt 20K
drwxr-xr-x   3 root     root     4,0K Mai  4 14:30 .
drwxr-xr-x 169 root     root      12K Mai 13 11:08 ..
drwxr-xr-x   3 postgres postgres 4,0K Mär  2  2016 9.1

Check the content in the directory /etc/postgresql/9.1 if it is currently in use (ie by checking the file last access dates). In case you are sure no app is using a PostgreSQL database you can remove the packages:

apt remove postgresql-common
apt remove postgresql-9.1
apt remove postgresql-server-dev-9.1

The restart the upgrade from console:
univention-upgrade --ignoreterm --ignoressh --updateto=4.2-0


closed #2