Univention Bugzilla – Bug 44160
update postgresql to 9.4 during UCS 4.2
Last modified: 2021-03-16 11:24:24 CET
We should update postgresql-9.1 to postgresql-9.4. (1) sdb article for the update (2) maybe we need a check in 4.2-1 to prevent the update if 9.1 is still installed?
(In reply to Felix Botner from comment #0) > We should update postgresql-9.1 to postgresql-9.4. We should require the migration to 9.4 before the 4.2-1 release: > (1) sdb article for the update > (2) we need a check in 4.2-1 to prevent the update if 9.1 is still installed
There is a Customer ID set so I set the flag "Enterprise Customer affected".
AFAICS 9.1 is EOL since quite a while: https://www.postgresql.org/support/versioning/ A customer asked for a migration guide to 9.4. AFAIK UCS 4.3 will ship 9.6, so we need a migration guide before the release of UCS 4.3, don't we?
ok, check for postgresql 9.1 in 4.3 preup and abort (link sdb atricle for migration from 9.1 to 9.4)
We also need a univention-postgresql-9.6 package in 4.3
a791aabb9d | univention-postgresql - Add univention-postgresql-9.6 3002ba0d6d | univention-updater - Add check_for_postgresql91 9ca30b15d5 | univention-appcenter - Add PostreSQL-9.6 drop PostreSQL-9.1 7b2171a591 | univention-pkgdb - Add PostreSQL-9.6 drop PostreSQL-9.1 ca405c74c0 | univention-printquota - Add PostreSQL-9.6 drop PostreSQL-9.1 81b0e669d4 | univention-appcenter - Add PostreSQL-9.6 drop PostreSQL-9.1 d51b89f4d5 | univention-pkgdb - Add PostreSQL-9.6 drop PostreSQL-9.1 343a5a08d4 | univention-printquota - Add PostreSQL-9.6 drop PostreSQL-9.1 9c7c7c9cb0 | Changelog Packages rebuilt. Migration guides: * UCS 4.2 postgresql-9.1 -> 9.4 : https://help.univention.com/t/8073 * UCS 4.3 postgresql-9.4 -> 9.6 : https://help.univention.com/t/8075 I did the second one directly now to check that UCR template subfiles have been migrated to 9.6 too.
ecac0e61e9 | test/utils/base_appliance.sh - Default to PostreSQL-9.6
REOPEN: You *must* to remove the old conffiles - renaming them is not sufficient! $srcpkg/debian/$binpkg.maintscript rm_conffiles /etc/univention/templates/files/etc/$path ${version_from_changelog}~ See <man:dh_installdeb(1)> and <https://git.knut.univention.de/univention/ucs/commit/30d64f60f5875fb877d2f5471d1c7ae46e687235> for an example.
Ok, I've adjusted the packages accordingly and rebuilt the packages. 7419812e48 | management/univention-appcenter d7a643dc14 | services/univention-pkgdb a81d5d4d2e | services/univention-printquota cfa3f43f5e | services/univention-pkgdb ca18fadcc7 | services/univention-pkgdb d52af121aa | management/univention-appcenter 04a6452cb5 | services/univention-printquota
OK: univention-install univention-postgres installs 9.6 on UCS 4.3 OK: a791aabb9d | Add univention-postgresql-9.6 OK: 3002ba0d6d -> 2898c5e1f | Add check_for_postgresql91 OK: 9ca30b15d5 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: 7b2171a591 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: ca405c74c0 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: 81b0e669d4 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: d51b89f4d5 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: 343a5a08d4 | Add PostreSQL-9.6 drop PostreSQL-9.1 OK: 9c7c7c9cb0 -> fbdd57f8 | Changelog OK: maintscript in u-appcenter, u-pkgdb, u-printquota OK: New UCS 4.3 install: Install nextcloud: u-postgres-9.6 installed OK: UCS 4.2 with postgres-9.1: Update blocked OK: https://help.univention.com/t/8073 -> update to 9.4 OK: migrate from 9.4 to 9.6: https://help.univention.com/t/8075 Verified
UCS 4.3 has been released: https://docs.software-univention.de/release-notes-4.3-0-en.html https://docs.software-univention.de/release-notes-4.3-0-de.html If this error occurs again, please use "Clone This Bug".