Univention Bugzilla – Bug 39366
Block update to UCS 4.1 if postgresql-8.4 is installed.
Last modified: 2015-11-17 12:12:03 CET
The update to UCS 4.1 should require postgresql-9.1 to be installed +++ This bug was initially created as a clone of Bug #36371 +++ postgresql-8.3 is removed during update (due to dependency problem) and replaced with postgresql-9.1. But the cluster is not automatically upgraded to 9.1 and the database is unusable after the update -> univention-pkgdb-scan --dump-all Traceback (most recent call last): File "/usr/sbin/univention-pkgdb-scan", line 37, in <module> univention.pkgdb.main() File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 538, in main connection = open_database_connection(config_registry, pkgdbu=False) File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 521, in open_database_connection connection = pgdb.connect(database=connectstring) File "/usr/lib/python2.7/dist-packages/pgdb.py", line 482, in connect dbtty, dbuser, dbpasswd) pg.InternalError: FATAL: kein pg_hba.conf-Eintrag f?r Host >>10.200.7.100<<, Benutzer >>master$<<, Datenbank >>pkgdb<<, SSL an -> dpkg -l| grep postgre rc postgresql-8.3 8.3.14-0.11. i386 object-relational SQL database, v ii postgresql-9.1 9.1.14-0.6.2 i386 object-relational SQL database, v ii postgresql-cli 9.1+134.23.2 all front-end programs for PostgreSQL ii postgresql-cli 8.3.14-0.11. i386 front-end programs for PostgreSQL ii postgresql-cli 8.4.20-0.19. i386 front-end programs for PostgreSQL ii postgresql-cli 9.1.14-0.6.2 i386 front-end programs for PostgreSQL ii postgresql-cli 134.23.20140 all manager for multiple PostgreSQL c ii postgresql-com 134.23.20140 all PostgreSQL database-cluster manag ii univention-pos 7.0.0-4.74.2 all UCS - postgresql configuration I think it is the best to block the update if postgresql-8.3 (7.4) is installed and refer to the postgres update article http://sdb.univention.de/1220 (currently only in german). Update with postgresql-8.4 works, postgresql-8.4 is not removed and postgresql-9.1 not installed during the update. Database still works. But we may need an acticle how to upgrade from 8.4 to 9.1.
univention-updater: r64353 block update if postgresql-8.4 is installed in preup.sh release notes: r64354 QA: install UCS 3.2 with horde app (postgresql-84), update to 4.1
(In reply to Felix Botner from comment #1) > univention-updater: r64353 Code review: OK > release notes: r64354 OK
Tests: OK
UCS 4.1 has been released: https://docs.software-univention.de/release-notes-4.1-0-en.html https://docs.software-univention.de/release-notes-4.1-0-de.html If this error occurs again, please use "Clone This Bug".