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

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Is there a way to log only a particular user connection attempts in Postgres?
Date: 2019-03-22 04:24:12
Message-ID: 1553228652335-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2019-03-22 04:55:13 Re: Is there a way to log only a particular user connection attempts in Postgres?
Previous Message M Jane 2019-03-21 15:47:33 Re: Running postgresql databases in Docker