Bug 57791 - [5.1] Keycloak 26 doesn't support postgesql-11 any longer
Summary: [5.1] Keycloak 26 doesn't support postgesql-11 any longer
Status: CLOSED FIXED
Alias: None
Product: UCS
Classification: Unclassified
Component: PostgreSQL
Version: UCS 5.1
Hardware: Other Linux
: P5 normal
Target Milestone: UCS 5.1
Assignee: Arvid Requate
QA Contact: Felix Botner
URL: https://git.knut.univention.de/univen...
Keywords:
Depends on:
Blocks: 57779
  Show dependency treegraph
 
Reported: 2024-12-03 15:37 CET by Arvid Requate
Modified: 2025-02-05 15:08 CET (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Customer ID:
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Arvid Requate univentionstaff 2024-12-03 15:37:06 CET
We need to prepare UCS 5.1-0 for the backport of postgresql-15 to 5.0-9 too.


+++ This bug was initially created as a clone of Bug #57779 +++

Keycloak 26 doesn't support postgesql-11 any longer.

One idea is to backport postgesql-15 from Debian Bookworm (UCS 5.2) to 5.0-9, but if we do that we need to ensure that:

* the postgresql migration works (ideally via diagnostic module)

* if we don't do a forced migration but e.g. via diagnostic module, then we have a transition phase, where we need to ensure that the new postgresql-common (248) works with the old postgresql-11

* the update from 5.0-9 to 5.2-0 works (via 5.1-0 / Debian bullseye)
Comment 1 Arvid Requate univentionstaff 2024-12-03 17:32:34 CET
Cherry picked package postgresql-common[173254] version 248 from 5.0-0-0[83]/errata5.0-9[703] to 5.1[84]/[0]
Cherry picked package postgresql-common[173254] version 248 from 5.1-0-0[84]/None[0] to 5.2[85]/[0]

3f1f719cd | Dummy patch to trigger repo-ng version timestamping
82e870237 | fixup

Package: postgresql-common                                                                                             
Version: 248A~5.1.0.202412031601                                                                                           
Branch: 5.1-0 

979e33b26 | Dummy patch to trigger repo-ng version timestamping

Package: postgresql-common
Version: 248A~5.2.0.202412031613
Branch: 5.2-0


Cherry picked package postgresql-15[173256] version 15.8-0+deb12u1 from 5.0-0-0[83]/errata5.0-9[703] to 5.1[84]/[0]
Cherry picked package postgresql-15[173256] version 15.8-0+deb12u1 from 5.1-0-0[84]/None[0] to 5.2[85]/[0]

597169d12 | Dummy patch to trigger repo-ng version timestamping

Package: postgresql-15
Version: 15.8-0+deb12u1A~5.1.0.202412031628
Branch: 5.1-0

0adf3b757 | Dummy patch to trigger repo-ng version timestamping

Package: postgresql-15
Version: 15.8-0+deb12u1A~5.2.0.202412031657
Branch: 5.2-0
Comment 2 Arvid Requate univentionstaff 2024-12-09 17:05:59 CET
5618937f6d0 | Backport postgresql-15
32a4bfe5b61 | Add metapackage univention-postgresql-15

Package: univention-appcenter
Version: 10.0.14
Branch: 5.1-0

Package: univention-pkgdb
Version: 14.0.7
Branch: 5.1-0

Package: univention-postgresql
Version: 13.0.4
Branch: 5.1-0
Comment 3 Felix Botner univentionstaff 2024-12-10 09:51:38 CET
OK, update works