[pgpool-hackers: 4344] Re: [pgpool-committers: 9433] pgpool: Feature: Support mutiple directories specification for pcp_sock

[Tatsuo Ishii]

Hi Ningwei,

Congratulations to your first contribution to Pgpool-II!

This is a great feature for upcoming Pgpool-II 4.5.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

From: NINGWEI CHEN <chen at sraoss.co.jp>
Subject: [pgpool-hackers: 4343] Re: [pgpool-committers: 9433] pgpool: Feature: Support mutiple directories specification for pcp_sock
Date: Tue, 6 Jun 2023 18:01:47 +0900
Message-ID: <20230606180147.c9ffb7d08d74dd226f291e15 at sraoss.co.jp>

> Hi,
> 
> I have pushed the patch to master branch to support pcp_socket_dir 
> for multiple directories specification.
> 
> Now you can define a list of directories separated by comma,
> which will be used for creating socket files for pcp commands.
> 
> If you have the following specification of pcp_socket_dir in your pgpool.conf,
> ===
> pcp_socket_dir = '/tmp,/var/tmp'
> pcp_port = 11001
> ===
> 
> after starting the pgpool-II, you will get two socket files in the specified directories.
> ===
> $ ls -la /tmp | grep 11001
> srwxrwxrwx   1 chen chen     0  6月  6 17:44 .s.PGSQL.11001
> $ ls -la /var/tmp | grep 11001
> srwxrwxrwx   1 chen chen    0  6月  6 17:44 .s.PGSQL.11001
> ===
> 
> And by using the -h options with pcp commands, you can chose the socket file you want.
> ===
> $ pcp_node_info -p 11001 -h /tmp
> localhost 11002 1 0.500000 waiting up standby standby 0 streaming async 2023-06-06 17:44:03
> localhost 11003 1 0.500000 waiting up primary primary 0 none none 2023-06-06 17:44:03
> $ pcp_node_info -p 11001 -h /var/tmp/
> localhost 11002 1 0.500000 waiting up standby standby 0 streaming async 2023-06-06 17:44:03
> localhost 11003 1 0.500000 waiting up primary primary 0 none none 2023-06-06 17:44:03
> ===
> 
> 
> Best Regards.
> -- 
> SRA OSS LLC
> Chen Ningwei<chen at sraoss.co.jp>
> 
> 
> On Tue, 06 Jun 2023 05:41:21 +0000
> Chen Ningwei <chen at sraoss.co.jp> wrote:
> 
>> Feature: Support mutiple directories specification for pcp_socket_dir.
>> 
>> Branch
>> ------
>> master
>> 
>> Details
>> -------
>> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=e7e03154ba1e0f6d30b30cbec771a5fc5c27068d
>> 
>> Modified Files
>> --------------
>> doc.ja/src/sgml/connection-settings.sgml           |  6 +-
>> doc/src/sgml/connection-settings.sgml              |  5 +-
>> src/config/pool_config_variables.c                 | 23 ++++----
>> src/include/pool_config.h                          |  3 +-
>> src/main/pgpool_main.c                             | 69 ++++++++++++++--------
>> src/pcp_con/pcp_child.c                            | 17 +++++-
>> src/sample/pgpool.conf.sample-stream               |  2 +-
>> src/test/regression/tests/035.unix_sockets/test.sh | 42 ++++++++++++-
>> src/utils/pool_process_reporting.c                 | 10 +++-
>> 9 files changed, 132 insertions(+), 45 deletions(-)
>> 
> 
> 
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers