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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match