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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Is there a way to log only a particular user connection attempts in Postgres?
Date: 2019-03-22 04:55:13
Message-ID: 939ba014-7c51-339e-c63b-e9cb5be10897@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 3/21/19 11:24 PM, 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

A user that can't log in isn't much of a user.

> and postgres user).

In a misguided, auditor-mandated attempt at security?

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafia Sabih 2019-03-22 08:27:24 Re: Running postgresql databases in Docker
Previous Message pavan95 2019-03-22 04:24:12 Is there a way to log only a particular user connection attempts in Postgres?