Scroll to navigation

PGPOOL SHOW(1) pgpool-II 4.1.4 Documentation PGPOOL SHOW(1)

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
2020 pgpool-II 4.1.4