[pgpool-general: 8603] PGPOOL SSL setup Issues

[Abhishek 1. Garg (Nokia)]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230215/f861d1f4/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15981 bytes
Desc: image001.png
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230215/f861d1f4/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 49644 bytes
Desc: pgpool.conf
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230215/f861d1f4/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-2023-02-15_135101.log
Type: application/octet-stream
Size: 10237 bytes
Desc: pgpool-2023-02-15_135101.log
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230215/f861d1f4/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pool_hba.conf
Type: application/octet-stream
Size: 3606 bytes
Desc: pool_hba.conf
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230215/f861d1f4/attachment-0002.obj>