pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Renee <renee.phillips@gmail.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pavan95 <pavan.postgresdba@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Is there a way to log only a particular user connection attempts in Postgres?
Date: Fri, 22 Mar 2019 08:05:06 -0400
Message-ID: <24180F86-D86D-4A00-9A46-7638927287AE@gmail.com> (raw)
In-Reply-To: <CAGDYbUNn4Sgbew3bBVCDvcwSisNHO8Bk=tLT-Zy8mXy7qC0WaA@mail.gmail.com>
References: <1553228652335-0.post@n3.nabble.com>
	<CAGDYbUNn4Sgbew3bBVCDvcwSisNHO8Bk=tLT-Zy8mXy7qC0WaA@mail.gmail.com>

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@gmail.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-activ...
> 
> 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
>> 

view thread (6+ messages)  latest in thread

Message-ID: <24180F86-D86D-4A00-9A46-7638927287AE@gmail.com>
Permalink:  ../24180F86-D86D-4A00-9A46-7638927287AE@gmail.com/
Also on:    postgresql.org/message-id/24180F86-D86D-4A00-9A46-7638927287AE@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: renee.phillips@gmail.com, shreeyansh2014@gmail.com, pavan.postgresdba@gmail.com
  Subject: Re: Is there a way to log only a particular user connection attempts in Postgres?
  In-Reply-To: <24180F86-D86D-4A00-9A46-7638927287AE@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox