Re: How to check postgres running or not ? - Mailing list pgsql-sql

Am Montag, 20. September 2004 12:05 schrieb Gaetano Mendola:
> It only depends on your distribution, in your case:
>
> ps aux | grep /usr/lib/postgresql/bin/postmaster | grep -v grep
>
> consider also the if you run different postmaster version in different
> location this is the only way I believe

Or maybe simply:

$ ps -C postmaster -F
UID        PID  PPID  C    SZ  RSS PSR STIME TTY          TIME CMD
postgres  1172     1  0  4339 2160   0 09:14 ?        00:00:00 /usr/lib/postgresql/bin/postmaster -D
/var/lib/postgres/data
postgres  1177  1172  0  2039 2776   0 09:14 ?        00:00:00 postgres: stats buffer process
postgres  1178  1177  0  1826 2048   0 09:14 ?        00:00:00 postgres: stats collector process
postgres  9935  1172  0  4443 2848   0 13:46 ?        00:00:00 postgres: pei template1 [local] idle

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/