Hide db name and user name in process list arguments

From: "Gavrina, Irina" <igavrina(at)mera(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Hide db name and user name in process list arguments
Date: 2011-02-16 14:50:28
Message-ID: 1958F96A86875D4F8B605C0E8054A8F1014FFFC8@gmail.merann.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Unix systems Postgres process list can be accessible through 'ps'
utility:

ps auxww | grep ^postgres
$ ps auxww | grep ^postgres
postgres 960 0.0 1.1 6104 1480 pts/1 SN 13:17 0:00
postmaster -i
postgres 963 0.0 1.1 7084 1472 pts/1 SN 13:17 0:00 postgres:
stats buffer process
postgres 965 0.0 1.1 6152 1512 pts/1 SN 13:17 0:00 postgres:
stats collector process
postgres 998 0.0 2.3 6532 2992 pts/1 SN 13:18 0:00 postgres:
tgl runbug 127.0.0.1 idle
postgres 1003 0.0 2.4 6532 3128 pts/1 SN 13:19 0:00 postgres:
tgl regression [local] SELECT waiting
postgres 1016 0.1 2.4 6532 3080 pts/1 SN 13:19 0:00 postgres:
tgl regression [local] idle in transaction

And each client connection has its command line which displays in form:

postgres: user database host activity

Is there any way to hide dbname and user name in displayed arguments of
client connections?

Thanks,

Irina

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2011-02-16 14:50:39 disable triggers using psql
Previous Message Aljoša Mohorović 2011-02-16 13:28:36 server setup/testing performance