| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to enable Logon Trigger in postgres? |
| Date: | 2018-08-21 06:16:52 |
| Message-ID: | CAKFQuwasjeC+z1akmaKxy4+1pxc3GP987_s_L-fQ0YzdP2KJSA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Monday, August 20, 2018, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> 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.
>
11 has been feature frozen for months, so that would be a no. It seems
unlikely that the described feature will make it into any core PostgreSQL
release at this time. Figuring out how to fit the existing log file based
auditing setup into your process will be the path of least resistance.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | soumik.bhattacharjee | 2018-08-21 06:43:14 | RE: Oracle 11g to PostgreSQL 10 - Database Migration |
| Previous Message | pavan95 | 2018-08-21 05:46:04 | Re: How to enable Logon Trigger in postgres? |