[pgpool-general: 8333] Problems starting pgpgool

Daniel Cristini dcristini at gmail.com
Wed Jul 13 04:10:04 JST 2022


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220712/f63a11d1/attachment-0001.htm>


More information about the pgpool-general mailing list