Hello
On 22/3/19 6:24 π.μ., pavan95 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).
You can't set that on a user level. At least not with pgsql 11. What you can do is use connection pooling (which is a good thing) so that login connections/disconnections will be not so frequent as to
create noise in your log files.
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
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
