[pgpool-general: 8335] Re: Problems starting pgpgool
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jul 13 10:20:15 JST 2022
What is the setting for "listen_addresses" of pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hi all
>
> I am trying to install pgpool and I am having problems testing with
> pgpool-setup it can't bind to a port and it refuses to start. I've tried
> multiple ports and of course checked that those ports are free
>
> Here's the log. I am using RHEL8 with postgres 13 installed from the Redhat
> Repository and installed pgpool 4.3.2 from source code
>
> 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing pool
> configuration
> 2022-07-12 14:54:20.040: main pid 3683880: DETAIL: num_backends: 2
> total_weight: 2.000000
> 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing pool
> configuration
> 2022-07-12 14:54:20.040: main pid 3683880: DETAIL: backend 0 weight:
> 1073741823.500000 flag: 0000
> 2022-07-12 14:54:20.040: main pid 3683880: DEBUG: initializing pool
> configuration
> 2022-07-12 14:54:20.040: main pid 3683880: DETAIL: backend 1 weight:
> 1073741823.500000 flag: 0000
> 2022-07-12 14:54:20.045: main pid 3683880: LOG: Backend status file
> /var/lib/pgsql2/log/pgpool_status discarded
> 2022-07-12 14:54:20.046: main pid 3683880: DEBUG: pool_coninfo_size:
> num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
> sizeof(ConnectionInfo) (160) = 2621440 bytes requested for shared memory
> 2022-07-12 14:54:20.046: main pid 3683880: LOG:
> health_check_stats_shared_memory_size: requested size: 12288
> 2022-07-12 14:54:20.046: main pid 3683880: LOG: memory cache initialized
> 2022-07-12 14:54:20.046: main pid 3683880: DETAIL: memcache blocks :64
> 2022-07-12 14:54:20.046: main pid 3683880: LOG: allocating (136981824)
> bytes of shared memory segment
> 2022-07-12 14:54:20.046: main pid 3683880: LOG: allocating shared memory
> segment of size: 136981824
> 2022-07-12 14:54:20.139: main pid 3683880: DEBUG: pool_coninfo_size:
> num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) *
> sizeof(ConnectionInfo) (160) = 2621440 bytes requested for shared memory
> 2022-07-12 14:54:20.139: main pid 3683880: LOG:
> health_check_stats_shared_memory_size: requested size: 12288
> 2022-07-12 14:54:20.139: main pid 3683880: LOG:
> health_check_stats_shared_memory_size: requested size: 12288
> 2022-07-12 14:54:20.139: main pid 3683880: LOG: memory cache initialized
> 2022-07-12 14:54:20.139: main pid 3683880: DETAIL: memcache blocks :64
> 2022-07-12 14:54:20.139: main pid 3683880: DEBUG: memory cache request
> size : 67108864
> 2022-07-12 14:54:20.144: main pid 3683880: LOG: pool_discard_oid_maps:
> discarded memqcache oid maps
> 2022-07-12 14:54:20.161: main pid 3683880: LOG: Setting up socket for
> ::1:11000
> 2022-07-12 14:54:20.161: main pid 3683880: LOG: Setting up socket for
> ::1:11000
> 2022-07-12 14:54:20.161: main pid 3683880: FATAL: failed to create INET
> domain socket
> 2022-07-12 14:54:20.161: main pid 3683880: DETAIL: bind on socket failed
> with error "Address already in use"
> 2022-07-12 14:54:20.164: main pid 3683880: LOG: shutting down
>
> Regards
>
> Daniel Cristini
More information about the pgpool-general
mailing list