[pgpool-general: 8335] Re: Problems starting pgpgool

[Tatsuo Ishii]

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