Re: pgpool question? - Mailing list pgsql-admin

From CaT
Subject Re: pgpool question?
Date
Msg-id 20070920115554.GU1140@zip.com.au
Whole thread Raw
In response to pgpool question?  ("Charles.Hou" <ivan.hou@msa.hinet.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Charles.Hou"
Date:
Subject: pgpool question?
Next
From: Григорий Титов
Date:
Subject: wholly / partially table read into shared buffer