[pgpool-general: 1069] load balancing

Khapare Joshi khapare77 at gmail.com
Wed Oct 3 22:44:35 JST 2012


hi all,

I have enabled load balancing in pgpool config. when I am inserting it
writes to both backend but when I query it seem it query only one backend.
Am I missing something ?

Oct  3 13:41:23 pgpool pgpool[1532]: DB node id: 1 backend pid: 10489
statement: SELECT TYPNAME FROM PG_TYPE WHERE OID=1043
Oct  3 13:41:23 pgpool pgpool[1532]: DB node id: 1 backend pid: 10489
statement: SELECT TYPNAME FROM PG_TYPE WHERE OID=1043
Oct  3 13:41:23 pgpool pgpool[1532]: DB node id: 1 backend pid: 10489
statement: SELECT TYPNAME FROM PG_TYPE WHERE OID=1043
Oct  3 13:41:23 pgpool pgpool[1532]: DB node id: 1 backend pid: 10489
statement: SELECT TYPNAME FROM PG_TYPE WHERE OID=23
Oct  3 13:41:23 pgpool pgpool[1532]: DB node id: 1 backend pid: 10489
statement: SELECT TYPNAME FROM PG_TYPE WHERE OID=1043


Does anybody has similar issue ?

K
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121003/a10fd5a4/attachment.html>


More information about the pgpool-general mailing list