Re: How to enable Logon Trigger in postgres?

On 21/08/18 17:46, pavan95 wrote:

> Hi all,
>
> Thanks for your responses. But to my wonder why can't these logon, logout be
> events for a postgres instance. If they are like any other
> INSERT/UPDATE/DELETE we can go with the triggers(logon trigger like in SQL
> server).
>
> It will be great if postgres 11 includes this feature in its native release.
>
>

It is certainly *possible*. But right now the event matrix - described here:

https://www.postgresql.org/docs/10/static/event-trigger-matrix.html

does *not* include logon/logoff events. Given that 11 is just about to 
be released, it won't include such a feature either. Now just to be 
clear, what you are asking for makes sense - having direct access to 
logon events rather than scraping the log file after then event - is a 
nice idea...we just don't have a patch to do that for version 11 (or 12) 
right now.

regards
Mark