[pgpool-general: 8608] Re: PGPOOL SSL setup Issues

[Bo Peng]

Hi,

> Error:
> 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node: make_persistent_db_connection_noerror failed on node 1

Pgpool-II uses the user specified in "sr_check_user" to fine the primary node.
Because sr_check_password is empty, Pgpool-II will read the password from pool_passwd file.
Please check if you have set the password correctly in pool_passwd file?

-------------------------
sr_check_user = 'pgpool'
sr_check_password = ''
-------------------------

On Wed, 15 Feb 2023 09:12:52 +0000
"Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com> wrote:

> Hi Team,
> 
> We are facing challenges in our Sandbox environment where we are trying to configure 2 PGPOOL nodes with 2 PostgreSQL servers(with Standby Replication).
> Refer attached conf file and logs.
> 
> Error:
> 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node: make_persistent_db_connection_noerror failed on node 1
> 
> Can you please suggest?
> 
> P.S. -     This setup works fine when pool_hba.conf is updated with below entries, result shown below
> hostssl all         all         0.0.0.0/0             trust
> 
> [cid:image001.png at 01D9414B.C5876E00]
> 
> Regards
> Abhishek Garg


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/