Configure LDAP for Postgres

Job ID: 40136852

Budget: $30 – $250 USD

I have a PostgreSQL 11 (or newer) instance running as a Windows service, and I’d like to switch its user authentication from the default method to our already-operational LDAP directory. The LDAP server is up and reachable on the network; I simply need the database side wired correctly so that log-ins are validated against LDAP instead of local roles.

The work involves:
• Editing pg_hba.conf and any relevant parameters in postgresql.conf to enable LDAP authentication and reloading the service without downtime.
• Verifying connectivity, binding credentials and search patterns.
• Walking me through a quick test with psql or pgAdmin to confirm that an LDAP user can connect and a non-LDAP user is rejected.
• Supplying a short note (markdown or text) summarising the final configuration so I can replicate it in staging later.

You may work via screen-share or send step-by-step instructions—whichever is quicker for you. Once the test user logs in successfully and the notes are delivered, the task is complete.
Related categories: Database Administration PostgreSQL