[pgpool-general: 4590] Re: find_primary_node failed ...

[Tatsuo Ishii]

> *(pgpool 3.4.2 and postgresql 9.3.5)*
> 
> During stress tests on my setup, PGpool has failed to find_primary node
> after a failover!
> the primary node has started but pgpool keep searched for it.
> (pgpool has be restarted in order find the primary)
> 
> can you please review the log (2016-03-22 03:03:XX) and advise why the
> primary node has been been detected??
> 
> scenario:
> 
> 1. killing the primary node.
> 2. pgpool performed a failover.
> 3. pgpool performs "follow master command".

find_primary_node() first connects to the primary node (host0)'s
postgres database as user = sr_check_user and password =
sr_check_password. Can you make sure that psql can connect to the
host0's postgres database with the user and password?

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