[pgpool-general: 8645] Failover doesn't promote standby server to new one (PgPool-II 4.1.3 PostGres 13)

Marco Ferrara m.ferrara at oppent.it
Thu Mar 16 20:16:03 JST 2023


Hi All,

i've configured the cluster following the guide https://www.pgpool.net/docs/41/en/html/example-cluster.html, so I obtain the situation with one primary and two standby.

  *   When I switch off pgpool service on primary e new pgpool is elected ad master and is ok
  *   When I switch off postgres, failover.sh is launched, a new postgres is promoted as primary but in show_pgpool_nodes the up nodes are all in standby mode. If I restart postgres service and pgpool service, on the elected standby it appears as new primary but no streaming with the others.

What I have to check?

Thanks,
MARCO FERRARA
IT Department

A.   OPPENT S.P.A. Via Fiuggi 38/A, 20159 Milano, Italy



[cid:image001.png at 01D95801.158612A0]

Company<https://www.oppent.com/> | Mobile Robots<https://www.oppent-evo.com/en/home-en/> | Trade Shows<https://mailchi.mp/4728f6798ffb/h27c0t4klb> | LinkedIn<https://www.linkedin.com/company/oppent-s-p-a-/?viewAsMember=true> | YouTube<https://www.youtube.com/channel/UCkb1VexnQ6PmMTFAlg0bgPA?view_as=subscriber>



[cid:image003.png at 01D95801.158612A0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230316/51ccae38/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 11179 bytes
Desc: image001.png
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230316/51ccae38/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 461 bytes
Desc: image002.png
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230316/51ccae38/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 103473 bytes
Desc: image003.png
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230316/51ccae38/attachment-0002.png>


More information about the pgpool-general mailing list