ps output and postgres

From: Eric Ridge <ebr(at)tcdi(dot)com>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: ps output and postgres
Date: 2004-02-11 22:38:45
Message-ID: 0D181A83-5CE3-11D8-984A-000A95BB5944@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I like how postgres backends modify the 'command' display in a (unix)
process listing to show what database they are connected to, and the
query being executed.

Has any thought been put into being able to make this configurable per
backend connection (maybe via a SET variable)? I'm thinking it would
be cool if a user process could provide its own status there,
identifying application-specific information. Similar to how Java
let's you set the "name" of a Thread (which sadly doesn't appear in a
process listing, but oh well).

I realize this could open up some security concerns by allowing us to
expose more information than we should, but for those of us that want
to shoot ourselves in the foot, it might be a useful feature.

Any thoughts?

eric

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-02-11 22:49:37 Re: DB cache size strategies
Previous Message Bruce Momjian 2004-02-11 22:14:06 Re: pg_dump/pg_restore problems with 7.4.1