View Issue Details

IDProjectCategoryView StatusLast Update
0000344Pgpool-IIBugpublic2017-10-05 15:33
Reporterlassizci Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionopen 
Product Version3.6.6 
Summary0000344: pgpool doesn't start with multiple listen_addresses
DescriptionTrying to configure pgpool with listen addresses as follows:

listen_addresses = '127.0.0.1,10.0.0.5'

pgpool doesn't start at all when configured like this. The config key is plural and the same as with postgresql, which accepts a comma separated list.

Tried also with space separated list, but in that case only the first address is picked.
Steps To Reproduce1. Configure multiple listen addresses separated with comma
2. Try to start pgpool
Additional Information2017-10-02 12:40:04: pid 6477: DEBUG: initializing pool configuration
2017-10-02 12:40:04: pid 6477: DETAIL: num_backends: 2 total_weight: 4.000000
2017-10-02 12:40:04: pid 6477: DEBUG: initializing pool configuration
2017-10-02 12:40:04: pid 6477: DETAIL: backend 0 weight: 1610612735.250000 flag: 0001
2017-10-02 12:40:04: pid 6477: DEBUG: initializing pool configuration
2017-10-02 12:40:04: pid 6477: DETAIL: backend 1 weight: 536870911.750000 flag: 0001
2017-10-02 12:40:04: pid 6477: DEBUG: loading hba configuration
2017-10-02 12:40:04: pid 6477: DETAIL: loading file :"/etc/pgpool2/pool_hba.conf" for client authentication configuration file
2017-10-02 12:40:04: pid 6477: DEBUG: pool_coninfo_size: num_init_children (150) * max_pool (2) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (136) = 5222400 bytes requested for shared memory
2017-10-02 12:40:04: pid 6477: DEBUG: ProcessInfo: num_init_children (150) * sizeof(ProcessInfo) (32) = 4800 bytes requested for shared memory
2017-10-02 12:40:04: pid 6477: DEBUG: Request info are: sizeof(POOL_REQUEST_INFO) 5304 bytes requested for shared memory
2017-10-02 12:40:04: pid 6477: DEBUG: Recovery management area: sizeof(int) 4 bytes requested for shared memory
2017-10-02 12:40:04: pid 6477: FATAL: failed to create INET domain socket
2017-10-02 12:40:04: pid 6477: DETAIL: getaddrinfo() failed: Name or service not known
TagsNo tags attached.

Activities

t-ishii

2017-10-02 23:04

developer   ~0001723

It's a known limitation and is on our TODO list.
https://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_comma_separated_IP_address_or_host_names_in_listen_addresses

You can use '*' instead for now.

Issue History

Date Modified Username Field Change
2017-10-02 21:46 lassizci New Issue
2017-10-02 23:04 t-ishii Note Added: 0001723
2017-10-05 15:33 t-ishii Status new => closed