[pgpool-general: 6339] psql: ERROR: unable to read message kind

[Benjamin Suqui]

Hi all,

I have two servers PostgresSQL Master/Slave - Replication
I also have a scenario where pgpool is running on the Master Server
All Server [Virtual Maschine] are running on:
Ubuntu 16.04.5 LTSpostgresql-9-5-pgpool2  version 3.4.3-1
pgpool2 version 3.4.3-1
psql (9.5.14)


Server Master: pgpool2 + PGsql Backend (primary): IP, 192.168.11.201Server Slave  :                   PGsql Backend (standby): IP, 192.168.11.212             


Server Master - pg_hba.conf
local   all             all                                 trust
host    replication     replicator     192.168.11.201/32      md5
host    replication     replicator     192.168.11.212/32      md5
host    replication     postgres       .exemple.de            md5

*************************

Server Slave - pg_hba.conf
host    replication     replicator     192.168.11.201/32      md5
host    replication     replicator     192.168.11.212/32      md5


with this line, can access the first node:
:~# pcp_node_count 10 localhost 9898 postgres SuperSecretPassword
2

but, I'm unable to connect to pgpool from the app hosts.
psql -p 5433 -U postgres testben

Ich habe this ERROR:
psql: ERROR: unable to read message kind
DETAIL: kind does not match between master(52) slot[1] (45)


LOG in Server B:
2018-12-13 04:45:50 PST [1952-1] postgres at testben FATAL: no pg_hba.conf entry for host "192.168.11.201", user "postgres", database "testben", SSL off

Thanks for your help
ben
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181213/96fb62fb/attachment.html>