[pgpool-general: 3513] Re: Problem with show pool_nodes
ishii at postgresql.org
Mon Mar 16 13:52:49 JST 2015
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
SRA OSS, Inc. Japan
> 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 ?
> 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