[pgpool-general: 8565] Re: PgPoolII 4.3.3 can't find Postgresql server
Tatsuo Ishii
ishii at sraoss.co.jp
Thu Jan 26 11:41:22 JST 2023
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
More information about the pgpool-general
mailing list