Compatibility of KC versions with PostgreSQL versions

semangard · June 25, 2021, 3:44pm

Hello,

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

Thanks and regards

semangard · June 29, 2021, 6:44am

In the startup logs with KC11 I have:
Using dialect: org.hibernate.dialect.PostgreSQL95Dialect…

Leo · June 29, 2021, 9:15am

Have the same question posted. In my case the reason for the same question was a backup feature of operator. We’re running latest operator with latest KC 14 on latest external PG 13.3 and the backup is not working. Complaining that pg_dumpall is looking for version 9.6 and the installed one is 13.3, so the backup is not working.

semangard · January 8, 2022, 10:34am

github.com

keycloak/keycloak-containers/blob/main/server/Dockerfile

FROM registry.access.redhat.com/ubi8-minimal

ENV KEYCLOAK_VERSION 18.0.2
ENV JDBC_POSTGRES_VERSION 42.3.3
ENV JDBC_MYSQL_VERSION 8.0.22
ENV JDBC_MARIADB_VERSION 2.5.4
ENV JDBC_MSSQL_VERSION 10.2.1.jre11

ENV LAUNCH_JBOSS_IN_BACKGROUND 1
ENV PROXY_ADDRESS_FORWARDING false
ENV JBOSS_HOME /opt/jboss/keycloak
ENV LANG en_US.UTF-8

ARG GIT_REPO
ARG GIT_BRANCH
ARG KEYCLOAK_DIST=https://github.com/keycloak/keycloak/releases/download/$KEYCLOAK_VERSION/keycloak-legacy-$KEYCLOAK_VERSION.tar.gz

USER root

RUN microdnf update -y && microdnf install -y glibc-langpack-en gzip hostname java-11-openjdk-headless openssl tar which && microdnf clean all

This file has been truncated. show original

https://jdbc.postgresql.org/documentation/changelog.html#version_all

semangard · March 16, 2022, 12:34pm

github.com/keycloak/keycloak

Officialy support newer versions of PostgreSQL

opened 12:29PM - 16 Mar 22 UTC

closed 09:15PM - 06 Jul 23 UTC

semangard

kind/enhancement

### Description Based on the [documentation](https://www.keycloak.org/server/…db): ![image](https://user-images.githubusercontent.com/57065741/158589604-bb87a0cc-6c28-47eb-953c-27bab8e59107.png) Only the version 10 of PostgreSQL is officialy supported. This is quite an old version and even the associated JDBC driver seems also very old https://github.com/keycloak/keycloak-containers/blob/main/server/Dockerfile (for KC legacy) vs https://jdbc.postgresql.org/documentation/changelog.html#version_all ==> Would it be possible to suppport newer versions of PostgreSQL (especially if PostgreSQL is one of the 2 main DB supported by KeyCloak) ? ### Motivation Benefit of latest enhancements and fxxes of PostgreSQL and follow up supported versions of PosgtreSQL https://www.postgresql.org/support/versioning/ ![image](https://user-images.githubusercontent.com/57065741/158590145-ceefde69-8250-48ee-86bc-d7529a8cee17.png) ### Discussion https://github.com/keycloak/keycloak/discussions/9232

Topic		Replies	Views
Compatibility of Keyclaok versions with PostgreSQL, RHEL And Windows server Versions Getting advice	1	657	August 12, 2021
What is the supported postgress db version for keycloak 13.0.1? Getting advice database	2	420	August 26, 2021
Will Keycloak 7 work with PostgreSQL version 13？	2	677	March 25, 2022
Postgres JDBC >= 42.2.9 [Keycloak-legacy 17.0.0] Configuring the server	1	389	March 16, 2022
Best setup versions of keycloak / postgres DB? Getting advice	2	249	June 10, 2023

Compatibility of KC versions with PostgreSQL versions

Related Topics