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

[Tatsuo Ishii]

> I tried with 2 node setup and now i went with 3 node setup.
> synchronous_standby_names = 'ANY 3 (azlpgNPBC2, azlpgN1hS0, azlpgN6Xm1)'
> in this *azlpgNPBC2* & *azlpgN6Xm1* are standby's and current  primary is
> *azlpgN1hS0. *

If you have tried with 3 and still see the error, I have no idea why
the error happens. Also I was not able to reproduce the problem.

$ pgpool_setup -n 4
$ echo "synchronous_commit = remote_apply" >> data0/postgresql.conf
$ echo "synchronous_standby_names = 'ANY 3 (server1, server2, server3)'" >> data0/postgresql.conf
$ ./startall
$ for i in 2 3 4 5 6 7 8 9
do
    psql -p 11000 -c "create database test$i" postgres
    psql -p 11000 -c "select 1" test$i
done

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