[GENERAL] Re: Repmgr + pgbouncer - Notification of master promotion toapplication level ... - Mailing list pgsql-general

From Daniel Silva
Subject [GENERAL] Re: Repmgr + pgbouncer - Notification of master promotion toapplication level ...
Date
Msg-id 1503496206990-5979699.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] Repmgr + pgbouncer - Notification of master promotionto application level ...  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Hi Andreas,

in my pgbouncer configured as:
;auth_file=/test/user.txt
auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1

Of course. When try connect with command " psql -p 6666  postgres -U dba"

Print erro in screen.
psql: ERROR:  No such user: dba

But, exists user and passwd in database. And try connect with "psql -p 5432
postgres -U dba"
success!



--
View this message in context:
http://www.postgresql-archive.org/Repmgr-pgbouncer-Notification-of-master-promotion-to-application-level-tp5966736p5979699.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: [GENERAL] PG and database encryption
Next
From: Igor Korot
Date:
Subject: Re: [GENERAL] What is the proper query