PGPOOL SHOW
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 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
- 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)