Univention Bugzilla – Bug 36371
Block update to UCS 4.0 if postgresql-8.3 is installed.
Last modified: 2015-09-18 16:04:14 CEST
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.
(In reply to Felix Botner from comment #0) > 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). Could you add a test to preup and refer to the article? The article needs to be translated. > 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. Yes, I've created an errata bug for this: Bug #36376.
(In reply to Stefan Gohmann from comment #1) > (In reply to Felix Botner from comment #0) > > 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). > > Could you add a test to preup and refer to the article? The article needs to > be translated. english version is already available http://sdb.univention.de/1249
r55278 | Bug #36371 Updater: Block on PostgreSQL-8.3 Package: univention-updater Version: 10.0.33-2.1304.201411031427 Branch: ucs_4.0-0 ReleaseNotes <http://jenkins.knut.univention.de:8080/job/UCS-4.0/job/UCS-4.0-0/job/Release%20Notes/110/artifact/webroot/release-notes-4.0-0-de.html#relnotes:removed> <http://jenkins.knut.univention.de:8080/job/UCS-4.0/job/UCS-4.0-0/job/Release%20Notes/110/artifact/webroot/release-notes-4.0-0-en.html#relnotes:removed>
postgresql-8.3 was only shipped until UCS-2.4-4 sec2, so how did you get it installed on a UCS-3 system? That check should have been added to the UCS-3 update some long time ago as any user is already using unmaintained software ...
(In reply to Philipp Hahn from comment #4) > postgresql-8.3 was only shipped until UCS-2.4-4 sec2, so how did you get it > installed on a UCS-3 system? > That check should have been added to the UCS-3 update some long time ago as > any user is already using unmaintained software ... System was installed with UCS 2.4-3 and updated to UCS 3.2-3.
please refer to the English sdb article: http://sdb.univention.de/1249
(In reply to Felix Botner from comment #6) > please refer to the English sdb article: http://sdb.univention.de/1249 r55295 | Bug #36371 Updater: Block update on postgresql-8.3 Package: univention-updater Version: 10.0.33-4.1306.201411031644 Branch: ucs_4.0-0
It is still http://sdb.univention.de/1220 in the (english) release notes.
(In reply to Felix Botner from comment #8) > It is still http://sdb.univention.de/1220 in the (english) release notes. r55363 | Bug #36371 Updater: Block on PostgreSQL-8.3 Switched English release notes to English SDB article 1249 <http://jenkins.knut.univention.de:8080/job/UCS-4.0/job/UCS-4.0-0/job/Release%20Notes/lastSuccessfulBuild/artifact/webroot/release-notes-4.0-0-en.html#relnotes:removed>
OK
UCS 4.0-0 has been released: http://docs.univention.de/release-notes-4.0-0-en.html http://docs.univention.de/release-notes-4.0-0-de.html If this error occurs again, please use "Clone This Bug".