Integrating with LDAP
This recipe shows you how to set up your PostgreSQL system so that it uses the Lightweight Directory Access Protocol (LDAP) for authentication.
Getting ready
Ensure that the usernames in the database and your LDAP server match, as this method works for user authentication checks of users who are already defined in the database.
Unfortunately, as LDAP is used only to validate username/password pairs, this method cannot use the PostgreSQL User Name Map feature to allow a single LDAP user to connect as multiple database users.
How to do it…
In the PostgreSQL authentication file, pg_hba.conf, we define some address ranges to use LDAP as an authentication method, and we configure the LDAP server for this address range:
host all all ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
