Re: User Authentication: LDAP and "local" accounts concurrently ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lentes, Bernd" <bernd(dot)lentes(at)helmholtz-muenchen(dot)de>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: User Authentication: LDAP and "local" accounts concurrently ?
Date: 2018-11-23 14:47:36
Message-ID: 23114.1542984456@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Lentes, Bernd" <bernd(dot)lentes(at)helmholtz-muenchen(dot)de> writes:
> i created a Postgres Server 9.6 on a SLES 12 SP3 box. In our institution we have a Windows ADS which i like to use to authenticate users via LDAP. But because there are several prerequisites to create such an account, which make things
> sometime complicated, i also like to create "local" users (users defined in the postgres DB itself).
> Is it possible to use both concurrently ? Some users autheticate via LDAP, others local.

I think you could put the two sets of users into different groups and then
specify those groups in two sets of pg_hba.conf entries.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-23 14:56:55 Re: Logical replication monitoring
Previous Message Lentes, Bernd 2018-11-23 14:36:42 User Authentication: LDAP and "local" accounts concurrently ?