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

[Tatsuo Ishii]

Not reproduced here (Ubuntu 20). Maybe OS setting problem?

https://stackoverflow.com/questions/39482704/why-do-i-get-duplicate-addrinfo-objects-in-the-linked-list-returned-by-getaddrin

> Hi
> 
> I am using pgpool_setup to test if it's working. So I am using localhost
> 
> On Tue, Jul 12, 2022 at 9:20 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> 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
>>