[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