Postgres logins over LDAP with Foxpass

Postgres requires StartTLS and doesn't support LDAPS (LDAP over TLS).

Here's the config for your pg_hba file.

You need to get your own values from the Foxpass dashboard for EXAMPLE, COM, BINDERUSER, and PASSWORD

host    all     all     0.0.0.0/0       ldap ldapserver=ldap.foxpass.com ldapport=389 ldaptls=1 ldapbasedn="dc=EXAMPLE,dc=COM" ldapbinddn="cn=BINDERUSER,dc=EXAMPLE,dc=COM" ldapbindpasswd=PASSWORD ldapsearchattribute=uid

Postgres also requires a local DB user account with the same username. Make a user without a password on the DB, and the password should be checked against LDAP.