Re: Number of Connections

On Fri, Feb 16, 2001 at 02:09:42PM -0500, Bryan White wrote:
> I use:
>     ps ax | grep postgres | wc -l
> Note the value is often one to high because is picks up the grep process.

Why not just remove 'grep' - i.e

ps ax | grep postgres | grep -v grep | wc -l

HTH,

Neil

-- 
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Four stages of acceptance:
    i) this is worthless nonsense;
    ii) this is an interesting, but perverse, point of view;
    iii) this is true, but quite unimportant;
    iv) I always said so. 
        -- J. B. S. Haldane in Journal of Genetics 58:464 (1963).