## Sergiu Velescu (sergiu.vele...@endava.com):
> OnLogin/Logout.
> I want to log/audit each attempt to login (successful and/or not).
log_connections/log_disconnections
> Who/how long was logged in DB (who logged in out of business hours
> (maybe deny access)).
Use PAM authentication.
> Set se
>
lot of this does pg_audit https://www.pgaudit.org/
these is a possibility to log - loging/logout, using DDL. - you can process
postgresql log.
regards
Pavel
>
> Have a nice day!
>
>
>
> *From:* Pavel Stehule
> *Sent:* Friday, January 24, 2020 10:03
can’t expect it to have everything a
commercial RDBMS have but at least we should start to think to implement this!
Have a nice day!
From: Pavel Stehule
Sent: Friday, January 24, 2020 10:03
To: Sergiu Velescu
Cc: pgsql-hack...@postgresql.org
Subject: Re: New feature proposal (trigger)
pá 24. 1
comprehensive the SQL and offer solutions (maybe
different execution plan, maybe offer suggestion to create a specific index…)).
Best regards.
From: Pavel Stehule
Sent: Thursday, January 23, 2020 18:39
To: Sergiu Velescu
Cc: pgsql-hack...@postgresql.org
Subject: Re: New feature proposal
pecific index…)).
>
> Best regards.
>
>
>
> *From:* Pavel Stehule
> *Sent:* Thursday, January 23, 2020 18:39
> *To:* Sergiu Velescu
> *Cc:* pgsql-hack...@postgresql.org
> *Subject:* Re: New feature proposal (trigger)
>
>
>
>
>
>
>
> čt 23. 1. 2020 v 1
Pavel Stehule writes:
> čt 23. 1. 2020 v 17:26 odesílatel Sergiu Velescu
> napsal:
>> I would like to propose a new feature which is missing in PgSQL but quite
>> useful and nice to have (and exists in Oracle and probably in some other
>> RDBMS), I speak about “Database Level” triggers: BeforePgS
čt 23. 1. 2020 v 17:26 odesílatel Sergiu Velescu
napsal:
> Dear PgSQL-Hackers,
>
>
>
> I would like to propose a new feature which is missing in PgSQL but quite
> useful and nice to have (and exists in Oracle and probably in some other
> RDBMS), I speak about “Database Level” triggers: BeforePgSt
Dear PgSQL-Hackers,
I would like to propose a new feature which is missing in PgSQL but quite
useful and nice to have (and exists in Oracle and probably in some other
RDBMS), I speak about "Database Level" triggers: BeforePgStart, AfterPgStarted,
OnLogin, OnSuccessfulLogin, BeforePGshutdown, On
