On Mon, Nov 15, 2010 at 10:11 AM, Tatsuo Ishii <[email protected]> wrote: > pgpoolAdmin kicks command line tools coming with pgpool-II > installation. These tool names start with "pcp_". I suspect it does > not work as expected. You can test if a pcp tool works or not by using > them directory. For example, DB node 0 (primary) info can be obtained > by pcp_node_info: > > $ pcp_node_info 0 localhost 9898 postgres pgpoolAdmin 0 > 5432 2 0.500000 > > This indicates that port is 5432, status if 2(up and connected) and > weight is 0.5(assuming that the user id is "postgres" and password is > "pgpoolAdmin" as specified in /usr/local/etc/pcp.conf). Can you please > verify it?
[r...@ip-10-228-239-143 pg_log]# pcp_node_info 0 localhost 9898 postgres xxxx 0 5432 1 0.500000 The password was changed following installation, but using the expected one instead of the default works as expected above. Running the command as the apache user works as well. >> In addition, clicking on Query Cache or Partitioning Rule, gives a >> completely empty response from the server. > > Query Cache/Partioning Rule gives no info is normal because no setting > for them was made in the instruction. However in this case I expect: > > Error Code e2001 > Error Message Database connection error occurred. > > rather than completely empty response from the server. Maybe wrong > html displayed? View Source shows there is no HTML returned at all. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
