[pgpool-general: 9306] Re: pgpool Connection issue: ERROR: unable to read message kind

Tatsuo Ishii ishii at postgresql.org
Wed Dec 25 13:20:28 JST 2024


> I revalidated everything and now the connection is established successfully
> to the DB via pgpool, but falling with the actual error.  I have tried
> using remote_apply, still seeing the same error.
> 
> Error in Virtual User 1: Error: Connection to database failed
> connection to server at "10.35.8.30", port 9999 failed: ERROR:  unable to
> read message kind
> DETAIL:  kind does not match between main(53) slot[1] (45)
> 
> here are my parameters
> 
> 
> *pgpool.conf*
> listen_addresses = '*'
> port = 9999
> pcp_listen_addresses = '*'
> backend_hostname0 = '10.35.8.30'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_hostname1 = '10.35.8.31'
> backend_port1 = 5432
> backend_weight1 = 1
> load_balance_mode = 'on'
> master_slave_mode = 'on'
> master_slave_sub_mode = 'stream'

What version of pgpool are you using?

> master_slave_mode = 'on'
> master_slave_sub_mode = 'stream'

These parameters are no longer valid in the supported versions of
pgpool.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list