[pgpool-general: 8788] Re: How many tables and functions are created by pgpool in postgresql?
Bo Peng
pengbo at sraoss.co.jp
Wed May 31 16:35:34 JST 2023
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/
More information about the pgpool-general
mailing list