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

From: Dave Page <dpage(at)pgadmin(dot)org>
To: abhishek s <as506373(at)gmail(dot)com>
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 09:22:35
Message-ID: CA+OCxox4ywH-bXwM+ZS4zqSxCS_2LrPsTU5Kw-SKYyfDGEG1wA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 abhishek s 2026-08-05 12:29:58 Re: Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information
Previous Message abhishek s 2026-08-04 17:17:35 Enhancement Request - Automatic Population of PostgreSQL application_name with Client Host Information