[pgpool-general: 3521] Re: Problem with show pool_nodes

[Christophe Le Roux]

Hello and thank you for your answer.

I will never use pcp_promote_node :).

Do you know why it display 2 standby nodes when I reboot the postgresql master node, and why I doesn't failover ?

My pgpool version is 3.4.1.

Cordialement,

Christophe Le Roux
Database engineer
christophe.le.roux at fr.clara.net








-----Message d'origine-----
De : Tatsuo Ishii [mailto:ishii at postgresql.org] 
Envoyé : lundi 16 mars 2015 05:53
À : Christophe Le Roux
Cc : pgpool-general at pgpool.net
Objet : Re: [pgpool-general: 3511] Problem with show pool_nodes

pcp_promote_node just changes the internal status regarding PostgreSQL servers.
If you actually want to promote a standby, you must either:

1) Install a failover script and handle promotion of standby by using
   pg_ctl or a failover file

2) Promote a standby by using pg_ctl or a failover file then restart pgpool-II

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

> Hello,
> 
> I've set up a postgresql and pgpool cluster on 2 nodes.
> Postgresql instances are 9.3.6 and use streaming replication.
> Pgpool are in HA mode.
> 
> You can see my pgpool config and pgpool.log in attachment.
> 
> When I shutdown the primary node, or if I promote the standby with pcp_promote_node at first show pool_nodes give good values, but after some seconds, it display  2 standby nodes.
> If I query pg_is_in_recovery()with the user configured in sr_check_user one is master and the other is standby (the failover process do his job).
> After a pgpool restart I have good value.
> 
> Can you help me to solve this problem ?
> 
> Cordialement,
> 
> Christophe Le Roux
> Database engineer
> christophe.le.roux at fr.clara.net<mailto:christophe.le.roux at fr.clara.net>
>