[pgpool-general: 7264] Keep old master after attach down node 0

[François]

Hello,

I have one pgpool in native replication mode connect to 2 postgres.

The initial configuration is:

 node_id |     hostname      | port | status | lb_weight |  role  |
---------+-------------------+------+--------+-----------+--------+
 0       | postgis           | 5432 | up     | 0.666667  | master |
 1       | postgis-replicate | 5432 | up     | 0.333333  | slave  |



 


Step 1 --> detach node 0

 node_id |     hostname      | port | status | lb_weight |  role  |
---------+-------------------+------+--------+-----------+--------+
 0       | postgis           | 5432 | down     | 0.666667  | slave |
 1       | postgis-replicate | 5432 | up     | 0.333333  | master |


Step 2 --> attach node 0

 node_id |     hostname      | port | status | lb_weight |  role  |
---------+-------------------+------+--------+-----------+--------+
 0       | postgis           | 5432 | up     | 0.666667  | master |
 1       | postgis-replicate | 5432 | up     | 0.333333  | slave |




The node 0 get's promoted after attach.
I was expecting the node 1 to remain as master.
Is there a way around this behavior ?

Kind Regards

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200908/2db710f6/attachment.htm>