NAME
PGPOOL_SHOW - show the value of a configuration parameterSYNOPSIS
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_parameterThe name of a Pgpool-II configuration
parameter. Available parameters are documented in Chapter 5, Server
Configuration, in the documentation.
Note
If the parameter contains uppercase letters (e.g. delegate_IP), the parameter
name must be enclosed in double quotes.
configuration_parameter_group
The name of the Pgpool-II configuration
parameter group. Currently there are three parameter groups.
backend
ALL
Configuration group of all backend config
parameters.
watchdog
Configuration group of all watchdog node
config parameters.
heartbeat
configuration group of all watchdog heartbeat
config parameters.
health_check
configuration group of all health check
parameters.
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)
PGPOOL SHOW write_function_list;
write_function_list
---------------------
nextval,setval
(1 row)
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)
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. hostname0 | localhost | Hostname of 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
| 2023 | pgpool-II 4.3.5 |