[pgpool-hackers: 3873] Re: Proposal: pyPCP and pcp_cli

[Tatsuo Ishii]

Perfect!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi,
> Yes both default .pcppass and PCP environment variable features are
> available in pyPCP.
> 
> Regards
> Umar Hayat
> 
> On Wed, Feb 10, 2021 at 6:25 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> Hi Umar,
>>
>> Looks good to me. One question. It is possible to have .pcppass file
>> so that users could avoid to input password while invoking PCP
>> commands. Does pcp_cli have the feature?
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Hi Hackers,
>> > Pgpool-II Communication Protocol (PCP) library and pcp_* utilities are
>> used
>> > to manage & monitor Pgpool-II cluster. Pgpool-II and these utilities are
>> > Linux based and to develop application and web interface you have to be
>> on
>> > some *nix system. Which limit the choice of integration of Pgpool-II with
>> > other systems and platforms. To overcome this limitation, I develop a
>> > Native Python based PCP library (which does not require Pgpool-II/PCP
>> > libarary) with name pyPCP. Being written in Python language it can be
>> used
>> > on any system. I tested pyPCP on Mac, Linux and Windows systems. pyPCP
>> can
>> > be found on github link: https://github.com/uhayat/pypcp
>> >
>> > Based  on pyPCP, a utility is also available in pyPCP github repository
>> > named pcp_cli.py. Currently there around 13 pcp_* utilities are being
>> built
>> > along with Pgpool-II. By the time we add more features/commands in PCP,
>> > number of these utilities will increase. pcp_cli combines functionality
>> of
>> > all those utilities in a single utility. Like Azure, Github CLIs, pcp_cli
>> > provide groups and sub-groups of command based on relevancy. I propose
>> > following structure for pcp_cli commands:
>> > pcp_cli pool status
>> > pcp_cli pool stop
>> > pcp_cli pool reload-config
>> > pcp_cli pool check-health-stats
>> > pcp_cli node count
>> > pcp_cli node info
>> > pcp_cli node attach
>> > pcp_cli node detach
>> > pcp_cli node promote
>> > pcp_cli node recovery
>> > pcp_cli process count
>> > pcp_cli process info
>> > pcp_cli watchdog info
>> >
>> > PyPCP and PCP_CLI will provide users freedom to develop applications and
>> > website across platforms. My next goal is to provide these utilities
>> using
>> > PIP, so that users can install them via pip command instead of cloning
>> > github repo.
>> >
>> > Waiting for suggestions and feedback to improve it further.
>> >
>> > Regards
>> > Umar Hayat
>>