Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-08-28 10:12:19 -0400, Tom Lane wrote:
>> Hm. Yeah, I guess there is some use in holding onto the values that were
>> actually used to initialize the current session, or at least there would
>> be if we exposed the cert contents in any fashion.
> Won't that allow the option to be specified at connection start by mere
> mortal users? That sounds odd to me.
Well, no, because SSL would be established (or not) before we ever process
the contents of the connection request packet. You might be able to
change the value that SHOW reports, but not the value actually governing
your session.
Having said that, there's a nearby thread about inventing a "SUBACKEND"
GUC category, and that's likely what we'd really want to use here, just
on the grounds that superusers would know better.
regards, tom lane