[pgpool-general: 8561] PgPoolII 4.3.3 can't find Postgresql server

Ron ronljohnsonjr at gmail.com
Thu Jan 26 02:23:48 JST 2023


The hostname commands in the primary and secondary servers match the 
contents of backend_hostname0 and backend_hostname1, yet getaddrinfo() says 
it can't find the servers.

What am I doing wrong?

postgres at FISPCCPGS405a pgpool-II]$ grep backend_hostname pgpool.conf
backend_hostname0 = 'FISPCCPGS405a'
backend_hostname1 = 'FISPCCPGS405b'

$ hostname
FISPCCPGS405a

$ ssh -q FISPCCPGS405b hostname
FISPCCPGS405b

2023-01-25 12:07:45.156: child pid 786204: DEBUG:  initializing backend status
2023-01-25 12:07:45.157: main pid 786138: WARNING:  failed to connect to 
PostgreSQL server, getaddrinfo() failed with error "Name or service not known"
2023-01-25 12:07:45.157: main pid 786138: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 0
2023-01-25 12:07:45.165: main pid 786138: DEBUG:  authenticate kind = 10
2023-01-25 12:07:45.172: main pid 786138: LOG:  find_primary_node: 
make_persistent_db_connection_noerror failed on node 1
2023-01-25 12:07:45.172: main pid 786138: DEBUG: 
pool_acquire_follow_primary_lock: lock was not held by anyone
2023-01-25 12:07:45.172: main pid 786138: DEBUG: 
pool_acquire_follow_primary_lock: succeeded in acquiring lock
2023-01-25 12:07:45.172: main pid 786138: DEBUG: verify_backend_node_status: 
there's no primary node
2023-01-25 12:07:45.172: main pid 786138: DEBUG: 
pool_release_follow_primary_lock called


-- 
Born in Arizona, moved to Babylonia.


More information about the pgpool-general mailing list