pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: Gaetano Mendola <mendola@bigfoot.com>
Cc: Worik <worik@noggon.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to check postgres running or not ?
Date: Mon, 20 Sep 2004 13:47:44 +0200
Message-ID: <200409201347.44410.peter_e@gmx.net> (raw)
In-Reply-To: <414EAB83.3060600@bigfoot.com>
References: <414A7395.8070503@vertex.co.in>
	<414E25B3.9070309@noggon.com>
	<414EAB83.3060600@bigfoot.com>

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/



view thread (22+ messages)  latest in thread

Message-ID: <200409201347.44410.peter_e@gmx.net>
Permalink:  ../200409201347.44410.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200409201347.44410.peter_e@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: peter_e@gmx.net, mendola@bigfoot.com, worik@noggon.com, tgl@sss.pgh.pa.us
  Subject: Re: How to check postgres running or not ?
  In-Reply-To: <200409201347.44410.peter_e@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox