Re: Proposal: wildcards in pg_service.conf

On Thu, Feb 28, 2008 at 11:27 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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