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

[Ron]

Hmm.  I assumed the default is 5432.

On 1/26/23 02:07, Tatsuo Ishii wrote:
> 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.

-- 
Born in Arizona, moved to Babylonia.