Ravi Soni

@nealoke You can try the #855 fix this would allow having a PGBouncer-type proxy behavior, and only on pool config would it allow connecting many databases; if the database is...

Hello @Vad1mo This fix works as you described: set one Pool on pgcat with Auth_quey config and make proxy = true (in my PR). This would dynamically create a pool...

Hello @Vad1mo, @nealoke The most important point this discussion misses is the need for an authentication configuration on PgCat based on an ``auth_query``. You need to set a Pool on...

@Vad1mo I implemented this fix in PgCat to handle opening many connections on the client application. I am working on a Java application and using PGBouncer with an ```Auth_query``` based...

@szguoxz PGBouncer and a transparent Proxy setup, all tenant databases are directly visible to the client, PgCat uses a proxy database (same as pool Name) and hides all the tenant...

Yes, both statements below are accurate. > > The PR of [@rvsoni](https://github.com/rvsoni) seems to (just) be about: > > * dynamic pool creation, based on the details in the connection(string)...

Hello @szguoxz Can you check my implementation of PGBouncer like proxy using ```auth_query``` base autnatication with dynamic pool creation https://github.com/rvsoni/pgcat https://hub.docker.com/r/rvsoni/pgcat

@bharling You need to use the Docker image https://hub.docker.com/r/rvsoni/pgcat and a config example from https://github.com/rvsoni/pgcat/blob/main/pgcat.toml to start. The most essential config is to use `aut_query` based login for the pool,...

Hi @SoulKyu This PR implementation solves the current limitations of your messages, 1) Each database requires its own pool configuration No, you need only one Pool Configuration to point to...

Hi @SoulKyu Did you try PR ? Let me know if you face any issue or need more info in this Ravi