[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