On Thu, Jul 20, 2017 at 8:47 AM, Yugo Nagata <nag...@sraoss.co.jp> wrote:
> Hi,
> Currently, PostgreSQL doen't have a hook triggered at session
> start. Although we already have ClientAuthentication_hook,
> this is triggered during authentication, so we can not
> access the database.
> If we have a hook triggerd only once at session start, we may
> do something useful on the session for certain database or user.
> For example, one of our clients wanted such feature. He wanted
> to handle encription for specific users, though I don't know
> the detail.
> The attached patch (session_start_hook.patch) implements such
> hook.
> Another patch, session_start_sample.patch, is a very simple
> example of this hook that changes work_mem values for sessions
> of a specific database.
> I would appreciate hearing your opinion on this hook.

I'm not sure your real needs but doesn't it material for improve Event


Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

Reply via email to