Provided by: pgpool2_4.1.4-6build1_amd64 
NAME
PGPOOL_SHOW - show the value of a configuration parameter
SYNOPSIS
PGPOOL SHOW configuration_parameter
PGPOOL SHOW configuration_parameter_group
PGPOOL SHOW ALL
DESCRIPTION
PGPOOL SHOW will display the current value of Pgpool-II configuration parameters. This command is similar
to the SHOW[1] command in PostgreSQL with an addition of PGPOOL keyword to distinguish it from the
PostgreSQL SHOW command.
PARAMETERS
configuration_parameter
The name of a Pgpool-II configuration parameter. Available parameters are documented in Chapter 5,
Server Configuration, in the documentation
configuration_parameter_group
The name of the Pgpool-II configuration parameter group. Currently there are three parameter groups.
backend
Configuration group of all backend config parameters.
other_pgpool
Configuration group of all watchdog node config parameters.
heartbeat
configuration group of all watchdog heartbeat node config parameters.
health_check
configuration group of all health check parameters.
ALL
Show the values of all configuration parameters, with descriptions.
EXAMPLES
Show the current setting of the parameter port:
PGPOOL SHOW port;
port
------
9999
(1 row)
Show the current setting of the parameter black_function_list:
PGPOOL SHOW black_function_list;
black_function_list
---------------------
nextval,setval
(1 row)
Show the current settings of all the configuration parameters belonging to backend group:
PGPOOL SHOW backend;
item | value | description
-------------------------+-------------------------+-----------------------------------------------------------
backend_hostname0 | 127.0.0.1 | hostname or IP address of PostgreSQL backend.
backend_port0 | 5434 | port number of PostgreSQL backend.
backend_weight0 | 0 | load balance weight of backend.
backend_data_directory0 | /var/lib/pgsql/data | data directory of the backend.
backend_flag0 | ALLOW_TO_FAILOVER | Controls various backend behavior.
backend_hostname1 | 127.0.0.1 | hostname or IP address of PostgreSQL backend.
backend_port1 | 5432 | port number of PostgreSQL backend.
backend_weight1 | 1 | load balance weight of backend.
backend_data_directory1 | /home/work/installed/pg | data directory of the backend.
backend_flag1 | ALLOW_TO_FAILOVER | Controls various backend behavior.
(10 rows)
Show all settings:
PGPOOL SHOW ALL;
item | value | description
-------------------------+-------------------------+-----------------------------------------------------------
backend_hostname0 | 127.0.0.1 | hostname or IP address of PostgreSQL backend.
backend_port0 | 5434 | port number of PostgreSQL backend.
backend_weight0 | 0 | load balance weight of backend.
backend_data_directory0 | /var/lib/pgsql/data | data directory of the backend.
backend_flag0 | ALLOW_TO_FAILOVER | Controls various backend behavior.
backend_hostname1 | 127.0.0.1 | hostname or IP address of PostgreSQL backend.
backend_port1 | 5432 | port number of PostgreSQL backend.
backend_weight1 | 1 | load balance weight of backend.
backend_data_directory1 | /home/work/installed/pg | data directory of the backend.
backend_flag1 | ALLOW_TO_FAILOVER | Controls various backend behavior.
other_pgpool_hostname0 | localhost | Hostname of other pgpool node for watchdog connection.
.
.
.
ssl | off | Enables SSL support for frontend and backend connections
(138 rows)
SEE ALSO
PGPOOL SET (PGPOOL_SET(1))
NOTES
1.
SHOW
https://www.postgresql.org/docs/current/static/sql-show.html
pgpool-II 4.1.4 2020 PGPOOL SHOW(1)