PGPOOL SHOW

pgpool-II 4.2.10 Documentation
Prev	Up		Next

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

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

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 write_function_list :

PGPOOL SHOW write_function_list;
write_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.
hostname0                | localhost               | Hostname of pgpool node for watchdog connection.
.
.
.
ssl                      | off                     | Enables SSL support for frontend and backend connections
(138 rows)