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 3139F329E60 for ; Mon, 20 Sep 2004 14:46:14 +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 53565-03 for ; Mon, 20 Sep 2004 13:46:05 +0000 (GMT) Received: from web41004.mail.yahoo.com (web41004.mail.yahoo.com [66.218.93.3]) by svr1.postgresql.org (Postfix) with SMTP id 0CCEF329E5F for ; Mon, 20 Sep 2004 14:46:07 +0100 (BST) Message-ID: <20040920134607.75051.qmail@web41004.mail.yahoo.com> Received: from [151.204.106.98] by web41004.mail.yahoo.com via HTTP; Mon, 20 Sep 2004 06:46:07 PDT Date: Mon, 20 Sep 2004 06:46:07 -0700 (PDT) From: Theodore Petrosky Subject: Re: How to check postgres running or not ? To: Arne Stoelck , Sandeep Gaikwad Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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/158 X-Sequence-Number: 19004 Funny... I set up a little program on my development machine that queries for the rendezvous name. This way I know my development machine is running before I try to connect. I think zeroconf could be used for this quite easily... JMHO Ted --- Arne Stoelck wrote: > > How about a simple > > " telnet localhost 5432 " ? > > assuming postmaster is listening on that host and > port > > > On Fri, 17 Sep 2004, 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. > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match > __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail