Hide db name and user name in process list arguments
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
Gavrina, Irina, 16.02.2011 15:50:
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 transactionAnd 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?
I think that's what the configuration property update_process_title is for.
Regards
Thomas
Thomas Kellerer <spam_eater@gmx.net> writes:
Gavrina, Irina, 16.02.2011 15:50:
Is there any way to hide dbname and user name in displayed arguments of client connections?
I think that's what the configuration property update_process_title is for.
No, that's just meant to suppress the overhead of updating the title for
each command. It doesn't prevent backends from advertising their dbname
and username once at startup. I think you'd have to modify the source
code to do that.
regards, tom lane
VTD-XML 2.10 is now released. It can be downloaded at
https://sourceforge.net/projects/vtd-xml/files/vtd-xml/ximpleware_2.10/.
This release includes a number of new features and enhancement.
* The core API of VTD-XML has been expanded. Users can now perform
cut/paste/insert on an empty element.
* This release also adds the support of deeper location cache support for
parsing and indexing. This feature is useful for application performance
tuning for
processing various XML documents.
* The java version also added support for processing zip and gzip files.
Direct processing of httpURL based XML is enhanced.
* Extended Java version now support Iso-8859-10~16 encoding.
* A full featured C++ port is released.
* C version of VTD-XML now make use of thread local storage to achieve
thread safety for multi-threaded application.
* There are also a number of bugs fixed. Special thanks to Jozef Aerts, John
Sillers, Chris Tornau and a number of other users for input and suggestions