[pgpool-general: 3521] Re: Problem with show pool_nodes
Christophe Le Roux
christophe.le.roux at fr.clara.net
Mon Mar 16 20:00:26 JST 2015
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>
>
More information about the pgpool-general
mailing list