Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Routing with same database name #828

Open
nik736 opened this issue Oct 3, 2024 · 0 comments
Open

Routing with same database name #828

nik736 opened this issue Oct 3, 2024 · 0 comments

Comments

@nik736
Copy link

nik736 commented Oct 3, 2024

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 nik736 changed the title Routing for DB with several usernames? Routing for same database name Oct 3, 2024
@nik736 nik736 changed the title Routing for same database name Routing with same database name Oct 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant