How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists.

What's the basic configuration that I should change in /var/lib/pgsql/9.4/data/pg_hba.conf and what else I should do?


Thanks everyone, I just made a change in /var/lib/pgsql/9.4/data/pg_hba.conf with :

local   all         all                               ldap ldapserver=ldap.server ldapport=389 ldaptls=0 ldapprefix="uid=" ldapsuffix=",ou=People,dc=domain,dc=com"

And the authentication works!


  1. Read the Friendly Manual:

http://www.postgresql.org/docs/9.5/static/auth-methods.html

  1. You probably want to use https://github.com/larskanis/pg-ldap-sync to sync your LDAP users and groups to PostgreSQL