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

Bo Peng pengbo at sraoss.co.jp
Fri Dec 14 08:36:27 JST 2018


Hi,

On Thu, 13 Dec 2018 13:29:49 +0000 (UTC)
Benjamin Suqui <bsuqui at yahoo.com> wrote:

> 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

According to the error message, you need to add entry 
for host 192.168.11.201.

> Thanks for your help
> ben


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan



More information about the pgpool-general mailing list