<div dir="ltr">Hi Ishii-San<br>While looking at the code for this bug report I found out that pgpool always bind the PCP listening socket to all addresses and ignore "pcp_listen_addresses" configuration<br><br>Snippet of related code in file:pgpool_main.c<br><br><font face="monospace, monospace">/* maybe change "*" to pool_config->pcp_listen_addresses */<br>pcp_inet_fd = create_inet_domain_socket("*", pool_config->pcp_port);<br></font><br>Do you remember any particular reason for that? Since this code same since the very beginning<br><br><br><div>Regards<br>Muhamamd Usama<div><div class="gmail_extra"><p class=""><br>On Wed, Jul 13, 2016 at 6:46 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br></p><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">Usama,<br>
<br>
Recently an issue regarding pcp command has been posted to our<br>
official pgpool-II mirror at GitHub. Can you please take a look at<br>
it?<br>
<br>
<a href="https://github.com/pgpool/pgpool2/issues/4" rel="noreferrer" target="_blank">https://github.com/pgpool/pgpool2/issues/4</a><br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
From: Zachary Sheets <<a href="mailto:notifications@github.com">notifications@github.com</a>><br>
Subject: [pgpool/pgpool2] [v3.5.3] PCP options from pgpool.conf not being used (#4)<br>
Date: Tue, 12 Jul 2016 12:38:17 -0700<br>
Message-ID: <pgpool/pgpool2/issues/<a href="mailto:4@github.com">4@github.com</a>><br>
<br>
> OS: ArchLinux<br>
> Kernel: 4.6.4-GrSec<br>
> PgSQL: 9.5.3<br>
> PgPool-II: 3.5.3<br>
><br>
> Compile-time options:<br>
> ``` bash<br>
> ./configure \<br>
> --prefix=/usr \<br>
> --with-openssl \<br>
> --sysconfdir=/etc/pgpool \<br>
> --mandir=/usr/share/man<br>
> ```<br>
><br>
> pgpool.conf (relevant options):<br>
> ``` bash<br>
> # ...<br>
> socket_dir = '/run/postgresql'<br>
> # ...<br>
> pcp_listen_addresses = ''<br>
> pcp_port = 9090<br>
> pcp_socket_dir = '/run/postgresql'<br>
> # ...<br>
> wd_ipc_socket_dir = '/run/postgresql'<br>
> # ...<br>
> ```<br>
><br>
> This file should be in ```/run/postgresql```, not in ```/tmp```:<br>
> ``` bash<br>
> # ls -lAt /tmp<br>
> total 0<br>
> srwxrwxrwx 1 root root 0 Jul 12 15:17 .s.PGSQL.9090<br>
> ```<br>
><br>
> The PCP service should not be listening on *any* address, let alone *every* address.<br>
> ``` bash<br>
> # ss -lnt | grep ':9090'<br>
> LISTEN 0 48 *:9090 *:*<br>
> ```<br>
><br>
> The ```pcp_pool_status``` tool is, according to documentation, supposed to be using the same ```pgpool.conf``` file as the main service. It either is not, or has its values hardcoded. No option is listed in the documentation to use a specific configuration file.<br>
> ``` bash<br>
> # pcp_pool_status -U <user><br>
> ERROR: connection to socket "/tmp/.s.PGSQL.9898" failed with error "No such file or directory"<br>
> ```<br>
><br>
> ---<br>
> You are receiving this because you are subscribed to this thread.<br>
> Reply to this email directly or view it on GitHub:<br>
> <a href="https://github.com/pgpool/pgpool2/issues/4" rel="noreferrer" target="_blank">https://github.com/pgpool/pgpool2/issues/4</a><br>
_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
</blockquote></div><br></div></div></div></div>