Re: [GENERAL] proctitle patch (useful)

>
> when trying to diagnose problems, it is sometimes difficult to identify which
> backend process is connected to what client process.
>
> here is a patch for src/backend/commands/variable.c
>
> this patch adds a new variable PROCTITLE.
>
> this allows client processes to set the backend proctitle to something useful:
>
> $ ps auxww | grep post
> 11080 ??  Is     0:00.06 postmaster -S -i -d 3 -o -F (postgres)
> 11125 ??  I      0:00.42 (postgres)
>
> $ psql database
> database=> SET PROCTITLE = 'testing proctitle 123';
> SET VARIABLE
> database=>
>
> $ ps ax | grep post
> 11080 ??  Is     0:00.06 postmaster -S -i -d 3 -o -F (postgres)
> 11125 ??  I      0:00.21 postmaster: testing proctitle 123 (postgres)
>
>
> i'm not overly familiar with GNU configure, so i'll leave it up to the people
> who manage the source to figure out a clean portable way of enabling the
> feature.

If we decide this is a nice feature addition, I would like it to use our
main PS_SET_STATUS() code rather than proctitle().

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026