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

[Tatsuo Ishii]

Can you share pgpool.conf and tell us where pgpool is running on,
FISPCCPGS405a or FISPCCPGS405b?

> 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.

In backend_hostname1 case, it seems pgpool failed to authenticate upon
connection. So the cause of errors are differ among backend_hostname0
and backend_hostname1.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> 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.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general