Re: Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information

From: abhishek s <as506373(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information
Date: 2026-08-05 12:29:58
Message-ID: CAE3Vk9nP+knnGMP9OsDh1JsHuS=+3FcyYNdbgAOBeB2GZmw+ug@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Dave,

What is the option then to know which user does any change in production
wth pgadmin using admin credentials?

On Wed, 5 Aug, 2026, 2:52 pm Dave Page, <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Wed, 5 Aug 2026 at 10:13, abhishek s <as506373(at)gmail(dot)com> wrote:
>
>> Hi team,
>>
>> Background
>> The current PostgreSQL audit logs in Azure record are below
>>
>> Database user
>>
>> Database name
>>
>> Client IP (appears as the Zscaler egress IP)
>>
>> Application name (currently pgAdmin4)
>>
>> Problem
>> Because the organization uses VPN or a similar proxy, PostgreSQL only
>> sees the proxy's IP address instead of the actual user's workstation IP.
>>
>> As a result:
>>
>> The Client IP is not useful for identifying who accessed the database.
>>
>> The application_name is always "pgAdmin4", which is static.
>>
>> Security and audit teams cannot determine:
>>
>> Which workstation connected
>>
>> Which employee initiated the connection
>>
>> Which machine executed the SQL statements
>>
>> Proposed Enhancement:
>> The request suggests that pgAdmin should automatically populate
>> PostgreSQL's application_name connection parameter with client metadata
>> when establishing the database connection.
>>
>
> You absolutely should NOT use application_name for security or audit
> purposes. It's a client-side parameter that a user can override in any way
> they like. Its purpose is to provide convenience when monitoring the server
> by identifying what a connection is being used for. That's fine for day to
> day monitoring with well behaved users, but you cannot rely on it for
> audit/security purposes as an attacker can simply override it.
>
> --
> Dave Page
> pgAdmin: https://www.pgadmin.org
> PostgreSQL: https://www.postgresql.org
> pgEdge: https://www.pgedge.com
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2026-08-05 12:37:26 Re: Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information
Previous Message Dave Page 2026-08-05 09:22:35 Re: Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information