[pgpool-general: 6652] Re: Cluster with 3 nodes

Tatsuo Ishii ishii at sraoss.co.jp
Fri Jul 26 17:54:57 JST 2019


Hi,

Yes, please provide log and config files.

My intuition is that there's something wrong with the follow master
command script or related settings (especially ssh), because the
script shutdowns standby server to resync with new primary database
server.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Гиа Хурцилава <khurtsilava.g at gmail.com>
> чт, 25 июл., 13:56 (21 час назад)
> кому: pgpool-general
> 
> Hi there.
> 
> I’ve got 3 machines with pgpool-4.0.5 and postgresql-11. I have done
> configuration for pgpool from the official documentations (
> http://www.pgpool.net/docs/latest/en/html/example-cluster.html) and
> everything works fine, except 1 thing. When I’m shutting down master node,
> one of the slaves is correctly promoted, and another one is going down with
> master. Just like that:
> 
> node_id | hostname | port | status | lb_weight |  role   | select_cnt |
> load_balance_node | replication_delay | last_status_change
> 
> ---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
> 
>  0       | master   | 5432 | down   | 0.333333  | standby | 0          |
> false             | 0                 | 2019-07-25 13:49:22
> 
>  1       | slave      | 5432 | up         | 0.333333  | primary | 0
>   | true              | 0                | 2019-07-25 13:49:22
> 
>  2       | reserve  | 5432 | down   | 0.333333  | standby | 0          |
> false             | 0                 | 2019-07-25 13:49:22
> 
> 
> 
> What reason can be of this behavior? How can I fix it?
> 
> If you’ll need logs or config files-let me know. Thanks.


More information about the pgpool-general mailing list