5

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?

user1070579
  • 141
  • 1
  • 3
  • 7

2 Answers2

6

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!

user1070579
  • 141
  • 1
  • 3
  • 7
3
  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
Neil McGuigan
  • 214
  • 4
  • 14