Postgres is able to check password against an entreprise directory using the LDAP protocol out of the box. ldap2pg automates the creation, update and removal of PostgreSQL roles and users based on entreprise organigram described in directory.

Managing roles is close to managing privileges as you expect roles to have proper default privileges. ldap2pg can grant and revoke privileges too.

Features

• Reads settings from an expressive YAML config file.
• Creates, alters and drops PostgreSQL roles from LDAP queries.
• Creates static roles from YAML to complete LDAP entries.
• Manages role members (alias groups).
• Grants or revokes privileges statically or from LDAP entries.
• Dry run, check mode.
• Logs LDAP queries as ldapsearch commands.
• Logs every SQL query.

Installation

The universal installation method is to download from PyPI using pip. Other methods and more details are described in documentation.

      $ pip install ldap2pg psycopg2-binary
    

ldap2pg is licensed under PostgreSQL license.

Support

The documentation includes a cookbook with many recipes for common deployment pattern. If you hit a bug or didn't found what you need in documentation, drop an issue on GitHub project.