On Thu, Feb 28, 2008 at 11:27 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> The LDAP case is the main motivation why I would like to have
> wildcards, so that all our databases could be handled with one
> entry in the service file. Currently we have to add an entry to the
> file for every new database we want to access.
I am very much +1 for it. I think it would be very useful.
> Do you think that the idea of wildcards for the service file
> is a bad one in general?
>
> Or could there be a more generally useful realization of that
> concept?
The use of [%] in pg_service.conf is well... ugly. :) (At the same time
I would have come up with exactly the same idea for the syntax...)
As for LDAP string expansion I think it would be convenient to
provide a subset of log_line_prefix %x expansions, like:
%u User name
%d Database name
%r Remote host name or IP address, and remote port
%h Remote host name or IP address
%% Literal %
...I am not sure if %r or %h is a good idea. Thoughts?
As for the syntax of configuration file, using [%] implies that things
like [proj%db] would also be valid, which would be harder to implement.
Perhaps empty bracers [] would be better? Ugly aswell, but would not
suggest you can use [pr%db%test] and expect it to work. And could
be made as 'last match' regardless of the in-file order.
Regards, Dawid