From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to enable Logon Trigger in postgres? |
Date: | 2018-08-21 10:58:48 |
Message-ID: | b2996173-c918-7272-16a1-16afa6de22bd@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | soumik.bhattacharjee | 2018-08-21 11:05:17 | RE: Oracle 11g to PostgreSQL 10 - Database Migration |
Previous Message | soumik.bhattacharjee | 2018-08-21 06:43:14 | RE: Oracle 11g to PostgreSQL 10 - Database Migration |