Re: libpq: system-wide root.crt - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: libpq: system-wide root.crt
Date
Msg-id 1285443518.5571.3.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: libpq: system-wide root.crt  (Magnus Hagander <magnus@hagander.net>)
Responses Re: libpq: system-wide root.crt
List pgsql-bugs
On fre, 2010-09-24 at 09:50 +0200, Magnus Hagander wrote:
> > I'm thinking, libpq could really use a global (and, for that matter, a
> > per-user) configuration file, where you could set defaults for some of
> > the things that you currently have to use environment variables for,
> > e.g., sslmode.  And then you can configure the system-wide root.crt
> > location there.
>
> We already have this - pg_service.conf - no?

Indeed.

> > Alternatively, if you think that that is overkill, then using an
> > environment variable to configure this feature would be consistent with
> > the existing mechanisms.
>
> So in this case, a "sslfallbackroot=/etc/somewhere" parameter, that
> you could then stick in etc/pg_service.conf, or in any of the other
> places you can specify it? The one thing I think would be really
> needed for that to work is to support wildcard database names in
> pg_service.conf?

Yes.

pgsql-bugs by date:

Previous
From: stagirus
Date:
Subject: Re: Mapping Hibernate boolean to smallint(Postgresql)
Next
From: Robert Haas
Date:
Subject: Re: BUG #5666: Pgadmin restore or back up database dont apper