Re: alter user set local_preload_libraries.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, masao(dot)fujii(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: alter user set local_preload_libraries.
Date: 2014-08-29 20:01:57
Message-ID: 5400DC35.9020204@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 8/28/14 9:01 AM, Kyotaro HORIGUCHI wrote:
> I found this issue when trying per-pg_user (role) loading of
> auto_analyze and some tweaking tool. It is not necessarily set by
> the user by own, but the function to decide whether to load some
> module by the session-user would be usable, at least, as for me:)

I think we could just set local_preload_libraries to PGC_USERSET and
document that subsequent changes won't take effect. That's the same way
session_preload_libraries works. That would avoid inventing another
very specialized GUC context.

If you're interested in improving this area, I also suggest you read the
thread of
<http://www.postgresql.org/message-id/1349829917.29682.5.camel@vanquo.pezone.net>.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2014-08-29 20:34:34 Re: Switch pg_basebackup to use -X stream instead of -X fetch by default?
Previous Message Robert Haas 2014-08-29 19:20:50 Re: On partitioning