[keycloak-user] Keycloak persistence - PostgreSQL schema?

Leonid Rozenblyum lrozenblyum at gmail.com
Fri Jul 6 05:37:25 EDT 2018


Hello.
I would like to integrate keycloak with db storage in an existing
PostgreSQL database (however in a separate keycloak-specific schema).

I tried to:
1) import the keycloak db creation sql script into the db and modifying
public. -> keycloak. (so all schema references point there) + places where
the unqualified access was used: added the schema prefix
2) provde 'current_schema' jdbc driver option

However this didn't work and keycloak still complained that the db should
be properly created.

Does keycloak support PostgreSQL schemas? Maybe something more should be
configured?
Thanks in advance for advice.


More information about the keycloak-user mailing list