X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9A1329E66 for ; Mon, 20 Sep 2004 01:35:17 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29096-05 for ; Mon, 20 Sep 2004 00:35:10 +0000 (GMT) Received: from grunt13.ihug.co.nz (grunt13.ihug.co.nz [203.109.254.60]) by svr1.postgresql.org (Postfix) with ESMTP id 197F2329E51 for ; Mon, 20 Sep 2004 01:35:11 +0100 (BST) Received: from 203-118-170-69.adsl.ihug.co.nz ([192.168.1.5]) [203.118.170.69] by grunt13 with asmtp (Exim 3.35 #1 (Debian)) id 1C9C97-0007KY-00; Mon, 20 Sep 2004 12:35:09 +1200 Message-ID: <414E25B3.9070309@noggon.com> Date: Mon, 20 Sep 2004 12:34:59 +1200 From: Worik User-Agent: Mozilla Thunderbird 0.8 (X11/20040918) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gaetano Mendola Cc: Tom Lane , pgsql-sql@postgresql.org Subject: Re: How to check postgres running or not ? References: <414A7395.8070503@vertex.co.in> <414CE76E.2050405@noggon.com> <414D7533.10708@3times25.net> <19430.1095611100@sss.pgh.pa.us> <414DF2D5.5040509@bigfoot.com> In-Reply-To: <414DF2D5.5040509@bigfoot.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/145 X-Sequence-Number: 18991 [snip] > > > Just to enforce the test is better looking for the entire executable path: > > ps aux | grep /usr/bin/postmaster | grep -v grep > Does not work for me! worik@stolberg:~$ ps aux | grep /usr/bin/postmaster | grep -v grep worik@stolberg:~$ ps aux | grep postmaster | grep -v grep postgres 670 0.1 0.6 8544 1688 pts/1 S 12:33 0:00 /usr/lib/postgresql/bin/postmaster worik@stolberg:~$ So... " ps aux | grep postmaster | grep -v grep " is more reliable(?) cheers Worik > > > Regards > Gaetano Mendola > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > >