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 21B3A329F1C for ; Sun, 19 Sep 2004 03:04:21 +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 05695-06 for ; Sun, 19 Sep 2004 02:04:19 +0000 (GMT) Received: from grunt15.ihug.co.nz (grunt15.ihug.co.nz [203.109.254.62]) by svr1.postgresql.org (Postfix) with ESMTP id 5E1A632A281 for ; Sun, 19 Sep 2004 02:57:06 +0100 (BST) Received: from 203-118-170-69.adsl.ihug.co.nz ([192.168.1.5]) [203.118.170.69] by grunt15.ihug.co.nz with asmtp (Exim 3.35 #1 (Debian)) id 1C8qwp-0007Bz-00; Sun, 19 Sep 2004 13:57:03 +1200 Message-ID: <414CE76E.2050405@noggon.com> Date: Sun, 19 Sep 2004 13:57:02 +1200 From: Worik User-Agent: Mozilla Thunderbird 0.8 (X11/20040918) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Sandeep Gaikwad Cc: pgsql-sql@postgresql.org Subject: Re: How to check postgres running or not ? References: <414A7395.8070503@vertex.co.in> In-Reply-To: <414A7395.8070503@vertex.co.in> 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/125 X-Sequence-Number: 18971 Assuming it is unix.... The command ps xau|grep post If it is running it will produce output like... worik@stolberg:~$ ps xau|grep post postgres 880 0.0 0.2 8580 740 ? S Sep07 0:31 /usr/lib/postgresql/bin/postmaster postgres 887 0.0 0.2 9536 612 ? S Sep07 0:02 postgres: stats buffer process postgres 889 0.0 0.2 8624 632 ? S Sep07 0:05 postgres: stats collector process worik 25927 0.0 0.2 1612 540 pts/10 S 13:54 0:00 grep post worik@stolberg:~$ If it is not running it will produce output like... worik@stolberg:~$ ps xau|grep post worik 26094 0.0 0.2 1608 528 pts/10 S 13:55 0:00 grep post Sandeep Gaikwad wrote: > > Hello Sir, > I want to know how to check whether postgres database is > running or not ? when I give command like ./postmaster -i &, whether > all databases in that postgres will run or any one [default] ? If any > one, then how to detect that database ? > > Thanks and regards, > Sandeep. > > > ------------------------------------------------------------------------ > > --------------------------------------------------------- > > Disclaimer: > > The contents of this message are confidential and intended to the addressee at the specified e-mail address only. Its contents may not be copied or disclosed to anyone other than the intended recipient. If this e-mail is received in error, please contact Vertex Software Pvt. Ltd immediately on +91 20 4041500 with details of the sender and addressee and delete the e-mail. Vertex Software Pvt. Ltd accepts no responsibility in the event that the onward transmission, opening or use of this message and/or any attachments adversely affects the recipient's systems or data. It is the recipient's responsibility to carry out such virus and other checks as the recipient considers appropriate. > > --------------------------------------------------------- > > > ------------------------------------------------------------------------ > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings