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