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.
- 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)