Re: PostgreSQL trigger on user logon

On Fri, Mar 18, 2022 at 7:47 AM Kevin Tu <kevintu888(at)gmail(dot)com> wrote:

> Hi team,
>
> We're switching over from Oracle to PostgreSQL, and apologies in advance
> if this is too newbie a question, but can we write a trigger in Posgres to
> record user logon for audit purposes? I'd thought there would be some
> "after/before logon trigger" that'll achieve this, but I've been googling
> around to no avail.
>
> This was discussed here last year. The net-net is to use this plugin:
https://github.com/splendiddata/login_hook

There were other options discussed - you can browse the thread here:
https://www.postgresql.org/message-id/CAN0SRDFZ-cDbuiu-_8oA4W1pU_oYkksydj8f2o7%2BO7XUwUfN4w%40mail.gmail.com

Hopefully that helps!
Steve