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

[Tatsuo Ishii]

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>
>