Hi Pavan,Go through the below link hope this will help you.https://dba.stackexchange.com/questions/118018/is-it-possible-to-exclude-specific-users-in-log-activity-of-postgresqlThanks & Regards,Shreeyansh DBA Teamwww.shreeyansh.comOn Fri, Mar 22, 2019 at 9:54 AM pavan95 <pavan.postgresdba@gmail.com> wrote:Hi Community, Is there any way to log a user login/connection attempts in a log file ? I know that we have log_connections parameter for this. But it logs all the connection attempts for all users across the instance. But here my requirement is to exclude login attempts for a particular user(as in my case its application user and postgres user). I have also seen "pg_audit" but it is not logging any login events. Please shed some light on this scenario. Looking forward to hear from you. Regards, Pavan Teja, 9841380956 -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Hi Community, Is there any way to log a user login/connection attempts in a log file ? I know that we have log_connections parameter for this. But it logs all the connection attempts for all users across the instance. But here my requirement is to exclude login attempts for a particular user(as in my case its application user and postgres user). I have also seen "pg_audit" but it is not logging any login events. Please shed some light on this scenario. Looking forward to hear from you. Regards, Pavan Teja, 9841380956 -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных