| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ldap connection parameter lookup |
| Date: | 2021-01-15 16:20:32 |
| Message-ID: | d359ef45df77cf0ebfdd68f03a329d8825e3cac1.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2021-01-15 at 14:09 +0000, Zwettler Markus (OIZ) wrote:
> I want to use ldap to lookup the connection parameters:
> https://www.postgresql.org/docs/12/libpq-ldap.html
>
>
> Do I have to create one static entry per database within pg_service.conf like:
>
> [mydatabase]
> ldap://ldap.mycompany.com/dc=mycompany,dc=com?description?one?(cn=mydatabase)
>
>
> or is there also some kind of generic variant like this (meaning lookup connection parameters for the database name I tell you somehow):
>
> [${PGDATABASE}]
> ldap://ldap.mycompany.com/dc=mycompany,dc=com?description?one?(cn=${PGDATABASE})
I proposed something like that a while ago:
https://postgr.es/m/D960CB61B694CF459DCFB4B0128514C2F3442B%40exadv11.host.magwien.gv.at
but it was rejected.
Perhaps you could come up with a better version.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2021-01-15 16:25:04 | Re: Best tools to monitor and fine tune postgres |
| Previous Message | Thomas Kellerer | 2021-01-15 16:10:01 | Re: Accounting for between table correlation |