Postgres Pro
Downloads
Home   >   mailing lists

Thread: Hide db name and user name in process list arguments

Hide db name and user name in process list arguments

From
"Gavrina, Irina"
Date:

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

Re: Hide db name and user name in process list arguments

From
Thomas Kellerer
Date:
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]
SELECTwaiting 
> postgres    1016    0.1    2.4    6532 3080 pts/1        SN      13:19      0:00 postgres: tgl regression [local]
idlein 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?

I think that's what the configuration property update_process_title is for.

http://www.postgresql.org/docs/current/static/runtime-config-statistics.html#GUC-UPDATE-PROCESS-TITLE

Regards
Thomas

Re: Hide db name and user name in process list arguments

From
Tom Lane
Date:
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

[ANN]VTD-XML 2.10

From
"Jimmy Zhang"
Date:
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