Install Kong database inside a custom schema

[mytototo]

Hey! I'd like to install Kong in a schema other than public inside my PostgreSQL. I couldn't find any info about it. Is it possible?

[thibaultcha]

That should be possible, see #1193 #1196.

[mytototo]

I saw those issues but it's weird to not find docs about it. There is no official explanation at all about how using it. Also, there is no config keys available.

[mytototo]

@thibaultcha Do you have a link/resource explaining how to configure such a thing?

[thibaultcha]

You would need to configure the search_path of your Kong user, see: https://www.postgresql.org/docs/9.1/static/runtime-config-client.html

Contributions to make this configurable from the Kong side are welcomed!

[karthikg001]

Just trying to be explicit here; create a postgresql user with the same name as the schema name and use it in kong, to achieve this.

[dimitryvoronov]

Just trying to be explicit here; create a postgresql user with the same name as the schema name and use it in kong, to achieve this.

Hello @karthikg001 how exactly to put a specific schema to use by a kong? Thanks.