[pgpool-general: 4339] Re: pgpool wd doesn't recognize the primary node

[Tatsuo Ishii]

> Hi everybody
> 
> I've deployed a cluster with 3 nodes, 1 Master and 2 standby in cascade streaming replication. Like this Master->Standby->Standby
> 
> I want configure pgpool in watchdog to a virtual IP and repmgr for failover manager. I've disabled the load balancing, health check, only configured the parameter for MASTER/SLAVE mode in the streaming replication.
> 
> When I start the pgpool wd and review nodes of the cluster, I see this:
> 
> postgres=# SHOW pool_nodes;
>  node_id | hostname | port | status | lb_weight |  role
> ---------+----------+------+--------+-----------+---------
>  0       | nodoa    | 5432 | 2      | 0.333333  | standby
>  1       | nodob    | 5432 | 2      | 0.333333  | standby
>  2       | nodoc    | 5432 | 2      | 0.333333  | standby
> (3 rows)
> 
> 
> My Master node is nodoa, but pgpool recognized the node like standby. Why the pgpool not recognize the primary node? I worry that in the failover, pgpool send the sql to a slave node and not send it to new master node.

Pgpool-II fails to recognize nodea as a primary for some reasons. Do
you see any error in the pgpool log? Also you might want to check the
FAQ:

http://pgpool.net/mediawiki/index.php/FAQ#How_does_pgpool-II_find_the_primary_node.3F

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