[keycloak-user] Keycloak persistence - PostgreSQL schema?

[Leonid Rozenblyum]

Thank you! Yes, it works.

On Fri, Jul 6, 2018 at 12:56 PM Dmitry Telegin <dt at acutus.pro> wrote:

> Hi Leonid,
>
> Could you please try the "schema" property in Keycloak database config?
>
>
> https://www.keycloak.org/docs/latest/server_installation/index.html#database-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
>
>