[pgpool-general: 1869] pgpoolAdmin not displaying Node info

Tony Neff tonyn at videx.com
Wed Jul 3 02:44:02 JST 2013

I've been setting up a test for streaming replication failover:

I have pgpool, a primary database and a secondary database each running on separate servers

pgpool 3.2.2
postgres 9.2.1
CentOS 6.3
php 5.3.3

Streaming replication is working. 

But, I've had some trouble getting pgpoolAdmin to work.

first there was a problem related to an unset timezone (a php 5.1 issue?). After setting the timezone i my php.ini file I started getting this error:

[Tue Jul 02 16:47:02 2013] [error] [client ::1] PHP Notice:  Undefined offset: 2 in /var/www/html/admin-tool/templates_c/2b624f64ab281dde67267c952c79a7a8c8b3c980.file.innerLog.tpl.php on line 64, referer: http://localhost/admin-tool/status.php

As a temporary work around, I removed the date function from the footer copywrite notice

pcp_node_info is working from the command line:

$  ./pcp_node_info 0 localhost 9898 postgres pgpoolAdmin 0 5432 2 0.500000
$ ./pcp_node_info 0 localhost 9898 postgres pgpoolAdmin 1 5432 2 0.500000

but I can't seem to get any node info or status through pgpoolAdmin. I checked the FAQ, but I do not have any errors in the apache error log.
I also have no problem connecting from my pgpool server to template1 on both database servers.

Videx, Inc. | 1105 NE Circle Blvd. | Corvallis, OR 97330 | (541) 738-5500
This email is intended only for the addressee(s) and may include material that is privileged, confidential, and protected from disclosure.  No contract is intended.  ©2013 Videx, Inc.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130702/32028525/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PastedGraphic-1.tiff
Type: image/tiff
Size: 213402 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130702/32028525/attachment-0002.tiff>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PastedGraphic-2.tiff
Type: image/tiff
Size: 87068 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130702/32028525/attachment-0003.tiff>

More information about the pgpool-general mailing list