Univention Bugzilla – Bug 51997
UCS-5: PostgreSQL-11
Last modified: 2021-05-25 15:59:54 CEST
Debian-10-Buster has PostgreSQL-11. Templaes in univention-postgresql must be updated.
univention-pkgdb (13.0.0-1) bec536ae4706 | Bug #51997 pkgdb: Postgresql 11 templates univention-postgresql (12.0.0-2) 6eda8ade15b4 | Bug #51997: PostgreSQL-11 univention-pkgdb (13.0.0-2) e6f7380fa443 | Bug #51997: Add postgres 11 template univention-appcenter (9.0.0-3) 643372b2edec | Bug #51997 appcenter: Postgresql 11 templates
Verified: * git commits * /etc/postgresql/11/main/postgresql.conf updated * Installation and test of univention-pkgdb Question: * Please comment on removal of services/univention-postgresql/conffiles/etc/cron.d/postgresql TODO: We should provide instructions for migration from 9.6 to 11, like we did for Bug 44160: https://help.univention.com/t/updating-from-postgresql-9-4-to-postgresql-9-6/8075 See also commit 2c28e5a960 Author: Philipp Hahn <hahn@univention.de> Date: Tue Jun 2 02:34:17 2020 +0200 Bug #51997: PostgreSQL-11 TODO: <https://www.debian.org/releases/stable/amd64/release-notes/ch-information.en.html#postgresql-reindex>>
TODO: * UCS-5 changelog * Check PostgreSQL release notes for important points: * https://www.postgresql.org/docs/release/10.0/ (...) * https://www.postgresql.org/docs/release/11.0/ (...11.10)
Ok https://www.postgresql.org/docs/9.1/routine-vacuuming.html#AUTOVACUUM states that "autovacuum = on" is the default, even though it's not explicitly set in /etc/postgresql/11/main/postgresql.conf.
https://wiki.postgresql.org/wiki/VACUUM_FULL
The test case fails due to this: https://jenkins.knut.univention.de:8181/job/UCS-5.0/job/UCS-5.0-0/view/Default/job/AutotestUpgrade/lastCompletedBuild/SambaVersion=s4,Systemrolle=master-part-II/testReport/86_selenium/132_miscellaneous_open_all_modules/master071/
libllvm7 and sysstat are missing on the DVD: # LANG=C apt install univention-pkgdb univention-postgresql univention-postgresql-11 postgresql-11 libllvm7 sysstat E: Package 'libllvm7' has no installation candidate E: Package 'sysstat' has no installation candidate
*** Bug 52491 has been marked as a duplicate of this bug. ***
I've written a draft for the migration guide: https://help.univention.com/t/updating-from-postgresql-9-6-or-9-4-to-postgresql-11/17531
(In reply to Arvid Requate from comment #9) > I've written a draft for the migration guide: > > https://help.univention.com/t/updating-from-postgresql-9-6-or-9-4-to- > postgresql-11/17531 I've done QA for that: OKAY with small changes. (In reply to Florian Best from comment #7) > libllvm7 and sysstat are missing on the DVD: OK: libllvm7 is on DVD UCS 5.0-0-rc0 OK: sysstat is only a recommends FYI: Components are no longer installed from USS. OK: apt install univention-pkgdb from ISO only OK: apt install univention-pkgdb from repository/online
> I've done QA for that: OKAY with small changes. Thanks, looks better.
UCS 5.0 has been released: https://docs.software-univention.de/release-notes-5.0-0-en.html https://docs.software-univention.de/release-notes-5.0-0-de.html If this error occurs again, please use "Clone This Bug".