pgcat icon indicating copy to clipboard operation
pgcat copied to clipboard

Routing with same database name

Open nik736 opened this issue 1 year ago • 0 comments

First of all thanks for pgcat. I have 3 different databases that I would like to route through one pgcat installation. All 3 databases have a default postgres or template1 database. How to configure pgcat in a way that I can connect from 3 users to the same database?

Basically: Database postgres with username user1 should route to server1 Database postgres with username user2 should route to server2 Database postgres with username user3 should route to server3

Since the pool name is the database name at the same time I am struggling with my scenario. Is this possible with pgcat? Any help is appreciated. Thanks a lot!

nik736 avatar Oct 03 '24 19:10 nik736