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

[Mukesh Tanuku]

pgpool - II 4.5.2

On Wed, Dec 25, 2024 at 9:50 AM Tatsuo Ishii <ishii at postgresql.org> wrote:

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241225/9e32908f/attachment.htm>