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

[Drako Kotipelto]

Hi Tatsuo 

Thanks for your prompt reply, I only see this error, but attached the complete log file. 

2016-01-18 13:06:50: pid 28217: LOG:  find_primary_node: checking backend no 0

2016-01-18 13:06:50: pid 28217: ERROR:  failed to authenticate
2016-01-18 13:06:50: pid 28217: DETAIL:  invalid authentication message response type, Expecting 'R' and received 'E'
2016-01-18 13:06:50: pid 28217: LOG:  find_primary_node: checking backend no 1

I guess the error is because health check is disabled. Or no?

Best Regards! 
Drako 

________________________________________
De: Tatsuo Ishii <ishii at postgresql.org>
Enviado: lunes, 18 de enero de 2016 05:27 p. m.
Para: drakoflames at hotmail.com
Cc: pgpool-general at pgpool.net
Asunto: Re: [pgpool-general: 4338] pgpool wd doesn't recognize the primary node

> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 3636 bytes
Desc: pgpool.log
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160119/c96e2bb6/attachment-0001.obj>