How To Configure PostgreSQL to Use LDAP for Authentication

Hi,

Please, I need help with how to configure postgresql to use LDAP for
Authentication.

*Here is what I have tried;*

host all all 0.0.0.0/0 ldap ldapserver=ldap://adserver.domain.com
ldapport=389 ldapprefix="DOMAIN\" ldapsuffix="" ldapbinddn=
postgres-user(at)domain(dot)com ldapbindpasswd=mypassword

host all all 0.0.0.0/0 ldap
ldapurl="ldaps://adserver.domain.com:636" ldapbasedn="OU=Users,OU=England
053,OU=Commercial Services,DC=domain,DC=com" ldapbinddn="
postgres-user(at)domain(dot)com" ldapbindpasswd="mypassword"
ldapsearchattribute="OU=Users,OU=England 053,OU=Commercial
Services,DC=domain,DC=com"

host all all 0.0.0.0/0 ldap
ldapserver="adserver.domain.com" ldapport=636 ldapscheme="ldaps"
ldapbasedn="OU=Users,OU=England 053,OU=Commercial
Services,DC=domain,DC=com" ldapbinddn="OU=Users,OU=England
053,OU=Commercial Services,DC=domain,DC=com"
ldapbindpasswd="mypassword" ldapsearchattribute="adservice-account"

*And this is the error I'm getting;*

[postgres(at)myserver ~]$ psql -U myuser mydatabase
psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432"
failed: FATAL: no pg_hba.conf entry for host "[local]", user "myuser",
database "mydatabase", no encryption
[postgres(at)myserver ~]$ psql -U "MYDOMAIN\myuser" mydatabase
psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432"
failed: FATAL: no pg_hba.conf entry for host "[local]", user
"MYDOMAIN\myuser", database "mydatabase", no encryption

Thank you

*Henry Ashu*

Database Administrator
*o:* 503.672.5114 | *f:* 800.551.8821 | DAT.com
[image: DAT Solutions] <https://www.dat.com/> [image: Like us on
Facebook] <https://www.facebook.com/loadboards> [image: Follow us on
Twitter] <https://twitter.com/loadboards> [image: Connect with us on
LinkedIn] <https://www.linkedin.com/company/datsolutions> [image: Visit
our YouTube Channel] <https://www.youtube.com/datloadboards> [image: Visit
us on Instagram] <https://instagram.com/dat_solutions>