Skip to content
This repository has been archived by the owner on Nov 17, 2023. It is now read-only.

unable to connect to database using multiple users #38

Open
Kumar6295 opened this issue Jul 12, 2021 · 0 comments
Open

unable to connect to database using multiple users #38

Kumar6295 opened this issue Jul 12, 2021 · 0 comments

Comments

@Kumar6295
Copy link

Kumar6295 commented Jul 12, 2021

We are using pgbouncer for connection to database.
we configure same database with different users but we are unable to connect to database ,it is giving below error.

ERROR

psql: error: ERROR: client_login_timeout

configuration

databases:
postgres_db:
host: localhost
port: 7778
user: postgres
dbname: postgres
auth_user: postgres
test_db:
host: localhost
port: 7778
user: postgres
dbname: test_db
auth_user: insight_user
portal_db:
host: localhost
port: 7778
user: postgres
dbname: test_db
auth_user: portal_user

users: {
postgres: postgres,
insight_user: X!q6DoGKc@iN,
portal_user : portal_user
}

psql -h localhost -p 5432 -d portal_db -U portal_user
password: portal_user
psql: error: ERROR: client_login_timeout

psql -h localhost -p 5432 -d test_db -U insight_user
password: X!q6DoGKc@iN
psql: error: ERROR: client_login_timeout

In users we need to mention auth_user and one of the password for user right??
Their no database password for particular user .

How we can connect database with multiple users??

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant