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

[Tatsuo Ishii]

Is the pgpool.conf actually used?
I am asking because backend_port0 is commented out.

> Conf file, and full log file are attached.  PgPool running on
> FISPCCPGS405a.
> 
> On 1/25/23 20:41, Tatsuo Ishii wrote:
>> 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
> 
> -- 
> Born in Arizona, moved to Babylonia.