<html><head></head><body><div class="ydpba682b8dyahoo-style-wrap" style="font-size: 10px;"><div><div><font size="2" face="verdana, helvetica, sans-serif"><span>Hi all,<br><br></span></font><div><font size="2" face="verdana, helvetica, sans-serif"><span>I have two servers PostgresSQL Master/Slave - Replication</span></font><font size="2" face="verdana, helvetica, sans-serif"><span><br></span></font></div><div><font size="2" face="verdana, helvetica, sans-serif"><span>I also have a scenario where pgpool is running on the Master Server</span></font></div><div><br><font size="2" face="verdana, helvetica, sans-serif"><span></span></font></div><div><div><span><font size="2" face="verdana, helvetica, sans-serif">All Server [Virtual Maschine] are running on:<br></font></span></div><div><span><font size="2" face="verdana, helvetica, sans-serif">Ubuntu 16.04.5 LTS</font></span></div><span><font size="2" face="verdana, helvetica, sans-serif">postgresql-9-5-pgpool2 version 3.4.3-1<br>pgpool2 version 3.4.3-1<br>psql (9.5.14)<br></font><br></span><br></div><font size="2" face="verdana, helvetica, sans-serif"><span></span></font><div><font size="2" face="verdana, helvetica, sans-serif"><span>Server <span><font size="2" face="verdana, helvetica, sans-serif"><span>Master</span></font></span>: pgpool2 + PGsql Backend (primary): IP, 192.168.11.201</span></font></div><font size="2" face="verdana, helvetica, sans-serif"><span>Server Slave : PGsql Backend (standby): IP, 192.168.11.212 <br><br><br>Server Master - pg_hba.conf<br>local all all trust<br>host replication replicator 192.168.11.201/32 md5<br>host replication replicator 192.168.11.212/32 md5<br>host replication postgres .exemple.de md5<br><br>*************************<br><br>Server Slave - pg_hba.conf<br>host replication replicator 192.168.11.201/32 md5<br>host replication replicator 192.168.11.212/32 md5<br></span></font><font size="2" face="verdana, helvetica, sans-serif"><span></span></font><div><br></div><div><br></div><font size="2" face="verdana, helvetica, sans-serif"><span>with this line, can access the first node:<br>:~# pcp_node_count 10 localhost 9898 postgres SuperSecretPassword<br>2<br><br>but, I'm unable to connect to pgpool from the app hosts.<br></span></font><div><font size="2" face="verdana, helvetica, sans-serif"><span>psql -p 5433 -U postgres testben</span></font></div><div><font size="2" face="verdana, helvetica, sans-serif"><span></span></font><br></div><div><br></div><font size="2" face="verdana, helvetica, sans-serif"><span>Ich habe this ERROR:<br>psql: ERROR: unable to read message kind<br>DETAIL: kind does not match between master(52) slot[1] (45)<br><br><br>LOG in Server B:<br>2018-12-13 04:45:50 PST [1952-1] postgres@testben FATAL: no pg_hba.conf entry for host "192.168.11.201", user "postgres", database "testben", SSL off<br><br></span></font><div><font size="2" face="verdana, helvetica, sans-serif"><span>Thanks for your help</span></font></div><div><font size="2" face="verdana, helvetica, sans-serif"><span><br></span></font></div></div><div class="ydpba682b8dsignature"><div><font size="2" face="verdana, helvetica, sans-serif"><span style="font-weight:bold;">ben</span></font></div><div><font size="2" face="verdana, helvetica, sans-serif"><span style="font-weight:bold;"><br></span></font></div></div></div></div></body></html>