[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