Re: [keycloak-user] Keycloak persistence - PostgreSQL schema?

Hi Leonid, Could you please try the "schema" property in Keycloak database config? https://www.keycloak.org/docs/latest/server_installation/index.html#datab... Cheers, Dmitry Telegin CTO, Acutus s.r.o. Keycloak Consulting and Training Pod lipami street 339/52, 130 00 Prague 3, Czech Republic +42 (022) 888-30-71 E-mail: info(a)acutus.pro On Fri, 2018-07-06 at 12:37 +0300, Leonid Rozenblyum wrote: 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. _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user