[pgpool-general: 8910] pgpool not connecting to db nodes

[sbob]

All;


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.


I installed the postgresql client package and pgpool on the pgpool node


I can run psql -h from the pgpool server to each of the postgreSQL nodes 
and connect without a password


I setup an empty pool_passwd file to disable the use of a password file.


I configured a backend0 and backend 1 section, but when I start pgpool I 
get errors related to connecting to the backend nodes:

2023-08-07 15:48:44.023: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 0
2023-08-07 15:48:44.026: main pid 3761: DEBUG:  authenticate kind = 0
2023-08-07 15:48:44.027: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 1
2023-08-07 15:48:44.027: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: lock was not held by anyone
2023-08-07 15:48:44.027: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: succeeded in acquiring lock
2023-08-07 15:48:44.028: main pid 3761: DEBUG: 
  verify_backend_node_status: there's no primary node
2023-08-07 15:48:44.028: main pid 3761: DEBUG: 
  pool_release_follow_primary_lock called
2023-08-07 15:48:45.031: main pid 3761: DEBUG:  authenticate kind = 0
2023-08-07 15:48:45.032: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 0
2023-08-07 15:48:45.035: main pid 3761: DEBUG:  authenticate kind = 0
2023-08-07 15:48:45.036: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 1
2023-08-07 15:48:45.036: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: lock was not held by anyone
2023-08-07 15:48:45.036: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: succeeded in acquiring lock
2023-08-07 15:48:45.036: main pid 3761: DEBUG: 
  verify_backend_node_status: there's no primary node
2023-08-07 15:48:45.036: main pid 3761: DEBUG: 
  pool_release_follow_primary_lock called
^C2023-08-07 15:48:46.040: main pid 3761: DEBUG:  authenticate kind = 0
2023-08-07 15:48:46.041: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 0
2023-08-07 15:48:46.044: main pid 3761: DEBUG:  authenticate kind = 0
2023-08-07 15:48:46.045: main pid 3761: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 1
2023-08-07 15:48:46.046: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: lock was not held by anyone
2023-08-07 15:48:46.046: main pid 3761: DEBUG: 
  pool_acquire_follow_primary_lock: succeeded in acquiring lock
2023-08-07 15:48:46.046: main pid 3761: DEBUG: 
  verify_backend_node_status: there's no primary node
2023-08-07 15:48:46.046: main pid 3761: DEBUG: 
  pool_release_follow_primary_lock called
2023-08-07 15:48:47.050: main pid 3761: DEBUG:  authenticate kind = 0



Thanks in advance for any help
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230807/904b9682/attachment.htm>