Paris, 6th October 2025
Dalibo announces the availability of ldap2pg 6.5. This version brings support for PostgreSQL 18 and several bug fixes. Follow the documentation to install this new version.
Since 2017, ldap2pg has offered the best solution for automatic synchronization of roles and privileges for PostgreSQL.
Configure LDAP authentication in the pg_hba.conf file,
then use ldap2pg to create and configure roles from your corporate directory.
PostgreSQL 18
PostgreSQL 18 brings a bit more strictness and requires some adjustments in the privilege inspection queries. These adjustments optimize all privilege inspection queries for all versions of PostgreSQL.
Routines, functions, procedures
In PostgreSQL,
the distinction between procedures and functions is very thin.
In fact, the CREATE PROCEDURE syntax has only existed since PostgreSQL 11.
PostgreSQL uses the ROUTINE keyword to treat functions and procedures interchangeably.
This is particularly the case for default privileges,
which cannot be distinguished between procedures and functions.
ldap2pg 6.5 better respects PostgreSQL’s nomenclature. Privileges on routines apply to both procedures and functions. Function management queries are now correctly limited to functions only.
Starting with ldap2pg 6.5,
it’s better to use __execute_on_routines__ than the equivalent for functions.
Other changes
ldap2pg 6.5 allows managing default privileges to oneself, applies user configuration to dynamic roles, and accepts managing databases with limited access. Finally, ldap2pg is available in the Ubuntu 24.04 repositories from Dalibo Labs.
For more information, see the changelog documentation. To update safely, disable scheduled ldap2pg tasks, test the synchronization manually with the new version, and validate the changes that this new version may bring.
Find the documentation in English, procedures, and community support at these addresses:
- Online documentation: http://ldap2pg.rtfd.io/en/latest/
- The project on GitHub: https://github.com/dalibo/ldap2pg
Étienne BERSAC and Pierre-Louis GONON develop ldap2pg, a project from Dalibo Labs. For any technical questions, the team recommends using the ldap2pg page on GitHub.
