Authenticate Postgresql client agains backend ldap
Posted on
We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication you can add these 3 lines to your current pg_hba.conf file:
|
1 2 3 |
host all username 127.0.0.1/32 ldap ldapserver="ourserver.uib.no" ldapbasedn="ou=people,dc=uib,dc=no" host all username 129.177.XXX.YYY/32 ldap ldapserver="ourserver.uib.no" ldapbasedn="ou=people,dc=uib,dc=no" local all username ldap ldapserver="ourserver.uib.no" ldapbasedn="ou=people,dc=uib,dc=no" |
where the first one will allow users that access the server from localhost (either from a shell or 127.0.0.1 connections). The second line […]