Compatibility of KC versions with PostgreSQL versions #9232

semangard · 2021-12-19T17:28:05Z

semangard
Dec 19, 2021

Hello,

Is there any documentation indicating wich the compliance between KeyCloak versions and Postgre versions ?
For example is its possible to run:
→ KC 16 + Postgre13
→ KC 16 + Postgre 9
Thanks and regards

myfirstnameispaul · 2022-02-14T18:57:57Z

myfirstnameispaul
Feb 14, 2022

They now have it in the documentation:

Database	Tested Version
mariadb	10
mssql	2016
mysql	8
oracle	12c
postgres	10

I'm also wondering what happens when I run it with PostgreSQL 13.

4 replies

semangard Mar 16, 2022
Author

#10767

dasniko Mar 16, 2022

I'm also wondering what happens when I run it with PostgreSQL 13.

Nothing special, it just ... works!

myfirstnameispaul Mar 17, 2022

@dasniko I feel like I'm missing something somewhere.

Based on the link in the issue, I was concerned that the JDBC driver (42.2.5) would preclude using anything later than 10, as support for even 11 wasn't added until 42.2.6.

dasniko Mar 17, 2022

Typically, a driver supporting a newer version, and thus the features of a newer version, does not prevent an older driver version to work with a newer db version. You just can't use the new features.

Additionally, even though the docs just mention PG 10, the driver shipped with KC 17 is 42.3.1

I've running a production environment with PG 13 without problems, also with older KC versions (since 14 or so). 🤷‍♂️
Just because KC is only tested with PG 10, it doesn't mean that it won't work with newer versions. I think, we can't expect the team to test KC against all possible database versions, that would be too much effort for an open source software you get for free!

tdduydev · 2023-07-07T14:48:16Z

tdduydev
Jul 7, 2023

I am using KC 21.1.2 fine with PG 15

1 reply

christian-2 Jul 9, 2023

In my case it's currently Keycloak 21.1.1 with PostgreSQL 15.3.

novatskij · 2023-07-13T17:55:23Z

novatskij
Jul 13, 2023

Hello!
Is there any chance that KC 21.x.x is tested with PG 14.x and versions are compatible?
Any evidences that KC 21.x.x does not use PG 15 only features are highly appreciated.

I have observed the documentation. Unfortunately, no any info related to my questions has been found
https://www.keycloak.org/server/db

0 replies

christian-2 · 2023-07-13T18:35:38Z

christian-2
Jul 13, 2023

I'd be optimistic also regarding PostgreSQL 14, for Hibernate should be able to bridge across most differences between DB versions. On the other hand, the relevant Keycloak guide specifically recommends PostgreSQL 15. A way to garner concrete evidence would perhaps be to run any version of PostgresSQL against the relevant tests.