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