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

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
>
>