[keycloak-user] Keycloak persistence - PostgreSQL schema?

[Dmitry Telegin]

Hi Leonid,

Could you please try the "schema" property in Keycloak database config?

https://www.keycloak.org/docs/latest/server_installation/index.html#dat
abase-configuration

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 at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user