pgcat
pgcat copied to clipboard
Routing with same database name
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!