>
> 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