Re: Repmgr + pgbouncer - Notification of master promotion to application level ...

From: Daniel Silva <daniel(dot)silva(at)ipm(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Repmgr + pgbouncer - Notification of master promotion to application level ...
Date: 2017-08-23 13:50:06
Message-ID: 1503496206990-5979699.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2017-08-23 13:54:57 Re: What is the proper query
Previous Message Condor 2017-08-23 05:09:49 Re: PG and database encryption