Re: Is there a way to log only a particular user connection attempts in Postgres?

Have you considered changing your logging format to csv?

The noise will still be in there but it’ll be in a form where you can query it.

> On Mar 22, 2019, at 4:51 AM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> wrote:
>
> 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(dot)postgresdba(at)gmail(dot)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
>>