[pgpool-general: 8788] Re: How many tables and functions are created by pgpool in postgresql?

[Bo Peng]

Hi,

If you run "CREATE EXTENSION pgpool_recovery", 
it will create the following functions:

template1=# CREATE EXTENSION pgpool_recovery;
CREATE EXTENSION
template1=# SELECT proname FROM pg_proc WHERE proname LIKE 'pgpool%';
       proname       
---------------------
 pgpool_pgctl
 pgpool_recovery
 pgpool_recovery
 pgpool_recovery
 pgpool_recovery
 pgpool_recovery
 pgpool_remote_start
 pgpool_switch_xlog
(8 rows)


If you run "CREATE EXTENSION pgpool_adm", 
it will create the following functions:

template1=# CREATE EXTENSION pgpool_adm;
CREATE EXTENSION
template1=# SELECT proname FROM pg_proc WHERE proname LIKE 'pcp%';
        proname         
------------------------
 pcp_attach_node
 pcp_attach_node
 pcp_detach_node
 pcp_detach_node
 pcp_health_check_stats
 pcp_health_check_stats
 pcp_node_count
 pcp_node_count
 pcp_node_info
 pcp_node_info
 pcp_pool_status
 pcp_pool_status
(12 rows)

https://www.pgpool.net/docs/latest/en/html/pgpool-adm.html

On Wed, 31 May 2023 14:34:16 +0800
Zhaoxun Yan <yan.zhaoxun at gmail.com> wrote:

> Hi guys!
> 
> I noticed many operations include executing sql commands to primary
> postgresql, like
> 
> psql -h $MAIN_NODE_HOST -p $MAIN_NODE_PORT -c "SELECT
> pgpool_switch_xlog('$ARCHIVEDIR')" template1
> 
> I wonder how many such functions or databases are created by pgpool?
> 
> Could you give an open list?
> 
> Regards,
>   Zhaoxun


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/