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

Tatsuo Ishii ishii at sraoss.co.jp
Wed Jul 13 10:55:17 JST 2022


Glad to hear that!

> That was exactly the problem. Thanks a lot
> 
> On Tue, Jul 12, 2022 at 9:37 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> 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
>> >>
>>


More information about the pgpool-general mailing list