[pgpool-general: 4332] unable to read message kind

Wolf Schwurack wolf at uen.org
Sat Jan 16 06:27:16 JST 2016


I'm unable to connect to pgpool from the app hosts. I have all of my entry in pool_hba.conf and pg_hba.conf but keeps give this error in pgpool.log

2016-01-15 14:11:25: pid 27553: LOG:  pool_read_kind: error message from 1 th backend:no pg_hba.conf entry for host "10.11.0.202", user "hosted_dev", database "research_quests", SSL off
2016-01-15 14:11:25: pid 27553: ERROR:  unable to read message kind
2016-01-15 14:11:25: pid 27553: DETAIL:  kind does not match between master(52) slot[1] (45)

I have two pgpool, two postgres master/slave all servers running on Ubuntu 14.4

Ubuntu 14.04.3 LTS
pgpool-II version 3.4.3 (tataraboshi)
psql (9.5.0)

postgres at pgtest-db:~$ grep hosted_dev pg_hba.conf
host    research_quests hosted_dev      10.11.0.202/32          trust

root at pgtest-con1:~# grep hosted_dev pool_hba.conf
host    research_quests hosted_dev      10.92.8.60/32           md5
host    research_quests hosted_dev      10.92.7.59/32           md5

Thanks for your help

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160115/08e88a1e/attachment.html>


More information about the pgpool-general mailing list