Re: How to check postgres running or not ?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: Worik <worik(at)noggon(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to check postgres running or not ?
Date: 2004-09-20 11:47:44
Message-ID: 200409201347.44410.peter_e@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2004-09-20 12:19:27 Re: How to check postgres running or not ?
Previous Message Gaetano Mendola 2004-09-20 10:05:55 Re: How to check postgres running or not ?