Currently only via PAM

Surfing the internet didn't find good howto for configuring pgbouncer pam ldap. Even in pgbouncer documentation good explaining auth_type md5, but not pam ldap. Maybee somebody can write a manual how to do it, trying to tune pam ldap authorization by myself haven't any success.

This one is quite good

@stevenwinfield This does not work normally, you can attach more detailed instructions on how to set it up if you tried it !?

@petere How long to wait for solutions to this problem?
Or can you somehow join the development? =)

@vldanch I'm not sure I could be more detailed than the "PgBouncer configuration" section of the link I previously gave...

• I compiled pgbouncer with PAM support
• I set auth_type = pam in pgbouncer.ini
• I created a PAM config file at /etc/pam.d/pgbouncer, similar to the one in the link, though we use pam_sss.so rather than pam_ldap.so:

auth        required      pam_env.so
auth        required      pam_access.so debug accessfile=<path/to/access/file>
auth        sufficient    pam_sss.so forward_pass
auth        required      pam_deny.so

Hello guys, any updates about LDAP support for pgbouncer?

LDAP support would be huge. Ideally all postgres auth mechanisms should be implemented at the connection pool layer, including kerberos.

Without LDAP support in PGBouncer I need to make the decision between connection pooling or LDAP. Would prefer to have both.

@petere did you take a look at this?