Multi tenancy with schemas

Hi,



What are your project requirements?


We have a limit on the number of concurrent active connections to the database. In this way the initial idea would be to have a pool of active connections that could be used by each database access request, in order to configure the default schema path (SET search_path TO xxxxx).

Thank you.

Isn't it what the multi tenant does? It shows how to create a multi tenant connection pool which holds several connection pools. For each connection pool ou can provide its size and define the maximum number of connections in the pool.


I don't understand your requirement compared to what exists in the multi tenant demo. I'd kindly ask you to be more detailed and precise in what you need and why the current demo doesn't fit your needs.


In this case you cannot have a pool of connections anyway. You will have to setup the connection for each and every incoming request you receive.