pgbouncer with ldap

From: Ayub M <hiayub(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgbouncer with ldap
Date: 2019-09-09 07:26:54
Message-ID: CAOS0qEsBc5hw8Q4_x5eg=Q-OY2_CM3DuSq-thth5tJ6v+ht7_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I am trying to setup pgbouncer with ldap to connect with rds
postgres. Downloaded latest version of pbbouncer (1.11) and using hba
auth_type. Getting below error when starting pgbouncer daemon. Am I
missing something?

[centos(at)ip-x(dot)x(dot)x(dot)x etc]$ pgbouncer -V
PgBouncer version 1.11.0

[centos(at)ip-x(dot)x(dot)x(dot)x etc]$ cat pg_hba.conf
host all user1 0.0.0.0/0 md5
host all all 0.0.0.0/0 ldap ldapserver=ldap-server.com ldapprefix="cn="
ldapsuffix=", dc=group, dc=com"

[centos(at)ip-x(dot)x(dot)x(dot)x etc]$ cat pgbouncer.ini | grep -v '^$' | grep -v '^;'
[databases]
db1 = host=xxx.rds.amazonaws.com port=5439 dbname=db1
[users]
[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_addr = *
listen_port = 5439
auth_type = hba
auth_file = /home/centos/pgbouncer-1.11.0/etc/userlist.txt
auth_hba_file = /home/centos/pgbouncer-1.11.0/etc/pg_hba.conf

[centos(at)ip-x(dot)x(dot)x(dot)x etc]$ pgbouncer -d pgbouncer.ini
2019-09-09 06:57:54.447 UTC [9465] WARNING hba line 2: unsupported method:
buf=ldap
2019-09-09 06:57:54.448 UTC [9465] WARNING could not parse hba config line 2

Regards,
Ayub

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2019-09-09 07:40:03 Re: pgbouncer with ldap
Previous Message Luca Ferrari 2019-09-09 06:48:51 Re: PG11.2 - wal_level =minimal max_wal_senders = 0