Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2E1459F99B7 for ; Thu, 20 Sep 2007 09:12:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 62149-04-2 for ; Thu, 20 Sep 2007 09:11:48 -0300 (ADT) X-Greylist: delayed 00:16:57.305965 by SQLgrey-1.7.5 Received: from bunyip.lochness.weebeastie.net (nessie.weebeastie.net [220.233.7.36]) by postgresql.org (Postfix) with ESMTP id E83FE9FA050 for ; Thu, 20 Sep 2007 09:11:52 -0300 (ADT) Received: from hogarth by bunyip.lochness.weebeastie.net with local (Exim 4.63) (envelope-from ) id 1IYKdO-0007tS-RI; Thu, 20 Sep 2007 21:55:54 +1000 Date: Thu, 20 Sep 2007 21:55:54 +1000 From: CaT To: "Charles.Hou" Cc: pgsql-admin@postgresql.org Subject: Re: pgpool question? Message-ID: <20070920115554.GU1140@zip.com.au> References: <1190264362.573512.71610@q5g2000prf.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1190264362.573512.71610@q5g2000prf.googlegroups.com> Organisation: Furball Inc. User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.131 tagged_above=0 required=5 tests=AWL=0.130, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200709/121 X-Sequence-Number: 26882 On Wed, Sep 19, 2007 at 09:59:22PM -0700, Charles.Hou wrote: > i have installed the pgpool in the server and start it. but how can i > know it's working? i means that the clients connected to the > database > by the pgpool. The latest versions of pgpool2 (I don't use pgpool) have connection logging, so you could use that. You could use netstat (under linux and most other unixes) to see what host:port connections are going to. You could use strace (under linux) on either the software or pgpool to see if the software is connection to the right place and/or that pgpool is getting connections. Just some ideas. :) -- "To the extent that we overreact, we proffer the terrorists the greatest tribute." - High Court Judge Michael Kirby