<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>All;</p>
<p><br>
</p>
<p>I am trying to setup a test pgpool setup, I created 2 PostgreSQL
nodes and set them up in a HOT Standby / Streaming Replication
environment.</p>
<p><br>
</p>
<p>I installed the postgresql client package and pgpool on the
pgpool node</p>
<p><br>
</p>
<p>I can run psql -h from the pgpool server to each of the
postgreSQL nodes and connect without a password</p>
<p><br>
</p>
<p>I setup an empty pool_passwd file to disable the use of a
password file.</p>
<p><br>
</p>
<p>I configured a backend0 and backend 1 section, but when I start
pgpool I get errors related to connecting to the backend nodes:<br>
<br>
<span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">2023-08-07
15:48:44.023: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 0
</span><br>
2023-08-07 15:48:44.026: main pid 3761: DEBUG: authenticate
kind = 0
<br>
2023-08-07 15:48:44.027: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 1
<br>
2023-08-07 15:48:44.027: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: lock was not held by anyone
<br>
2023-08-07 15:48:44.027: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: succeeded in acquiring lock
<br>
2023-08-07 15:48:44.028: main pid 3761: DEBUG:
verify_backend_node_status: there's no primary node
<br>
2023-08-07 15:48:44.028: main pid 3761: DEBUG:
pool_release_follow_primary_lock called
<br>
2023-08-07 15:48:45.031: main pid 3761: DEBUG: authenticate
kind = 0
<br>
2023-08-07 15:48:45.032: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 0
<br>
2023-08-07 15:48:45.035: main pid 3761: DEBUG: authenticate
kind = 0
<br>
2023-08-07 15:48:45.036: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 1
<br>
2023-08-07 15:48:45.036: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: lock was not held by anyone
<br>
2023-08-07 15:48:45.036: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: succeeded in acquiring lock
<br>
2023-08-07 15:48:45.036: main pid 3761: DEBUG:
verify_backend_node_status: there's no primary node
<br>
2023-08-07 15:48:45.036: main pid 3761: DEBUG:
pool_release_follow_primary_lock called
<br>
^C2023-08-07 15:48:46.040: main pid 3761: DEBUG: authenticate
kind = 0
<br>
2023-08-07 15:48:46.041: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 0
<br>
2023-08-07 15:48:46.044: main pid 3761: DEBUG: authenticate
kind = 0
<br>
2023-08-07 15:48:46.045: main pid 3761: LOG: find_primary_node:
make_persistent_db_connection_noerror failed on node 1
<br>
2023-08-07 15:48:46.046: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: lock was not held by anyone
<br>
2023-08-07 15:48:46.046: main pid 3761: DEBUG:
pool_acquire_follow_primary_lock: succeeded in acquiring lock
<br>
2023-08-07 15:48:46.046: main pid 3761: DEBUG:
verify_backend_node_status: there's no primary node
<br>
2023-08-07 15:48:46.046: main pid 3761: DEBUG:
pool_release_follow_primary_lock called
<br>
2023-08-07 15:48:47.050: main pid 3761: DEBUG: authenticate
kind = 0<br>
<br>
<br>
</span></p>
<p><br>
</p>
<p>Thanks in advance for any help<br>
</p>
</body>
</html>