On Wed, 7 Mar 2018 10:19:35 -0500 Stephen Frost <sfrost@xxxxxxxxxxx> wrote: > Greetings, > > * Bjørn T Johansen (btj@xxxxxxxxxx) wrote: > > Is it possible to use one authentication method as default, like LDAP, and if the user is not found, then try to authenticate using > > md5/scram-sha-256 ? > > Not directly in pg_hba.conf. You might be able to construct a system > which works like this using PAM though, but it wouldn't be much fun. > > LDAP use really should be discouraged as it involves sending the > password to the PG server. If you are operating in an active directory > environment then you should be using GSSAPI/Kerberos. > > SCRAM is a good alternative as it doesn't send the password to the > server either, though that is only available in PG10, of course. > > Thanks! > > Stephen Ok, thx... Will check out GSSAPI/Kerberos instead... :) BTJ
