3 thoughts on “Waiting for PostgreSQL 17 – Add support event triggers on authenticated login”

  1. Is it also possible to create an EVENT TRIGGER “ON logout”?

  2. Oracle “login trigger”(s) come to mind here.
    Probably because I lived so many years without, I cannot figure out right now which purpose they can have in PostgreSQL except for a little auditing or per-user settings, when you are not using a pooler.
    And I am curious about performances.

  3. IBM Db2 has CONNECT_PROC parameter at database level. Admin can create stored procedure and then update above parameter with stored procedure name.

    I have used it to collect users client version and to get SSL/TLS version. This indicated who is using old clients and needs to upgrade client, before I have performed restrictions on database.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.