Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to log only a particular user connection attemptsin Postgres? - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Is there a way to log only a particular user connection attemptsin Postgres?
Date
Msg-id CAGDYbUNn4Sgbew3bBVCDvcwSisNHO8Bk=tLT-Zy8mXy7qC0WaA@mail.gmail.com
Whole thread Raw
In response to Is there a way to log only a particular user connection attempts inPostgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: Is there a way to log only a particular user connection attempts in Postgres?  (Renee <renee.phillips@gmail.com>)
Re: Is there a way to log only a particular user connection attemptsin Postgres?  (Michael Banck <mbanck@gmx.net>)
List pgsql-admin
Tree view
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-postgresql

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On 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

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Is there a way to log only a particular user connection attemptsin Postgres?
Next
From: Renee
Date:
Subject: Re: Is there a way to log only a particular user connection attempts in Postgres?