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

[Umar Hayat]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20210218/9e54dbae/attachment.htm>