'\" t .\" Title: PGPOOL SHOW .\" Author: The Pgpool Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot .\" Date: 2023 .\" Manual: pgpool-II 4.3.7 Documentation .\" Source: pgpool-II 4.3.7 .\" Language: English .\" .TH "PGPOOL SHOW" "1" "2023" "pgpool-II 4.3.7" "pgpool-II 4.3.7 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" PGPOOL_SHOW \- show the value of a configuration parameter .SH "SYNOPSIS" .sp .nf PGPOOL SHOW \fIconfiguration_parameter\fR PGPOOL SHOW \fIconfiguration_parameter_group\fR PGPOOL SHOW ALL .fi .SH "DESCRIPTION" .PP \fBPGPOOL SHOW\fR will display the current value of Pgpool\-II configuration parameters\&. This command is similar to the \m[blue]\fB\fBSHOW\fR\fR\m[]\&\s-2\u[1]\d\s+2 command in PostgreSQL with an addition of PGPOOL keyword to distinguish it from the PostgreSQL SHOW command\&. .SH "PARAMETERS" .PP \fIconfiguration_parameter\fR .RS 4 The name of a Pgpool\-II configuration parameter\&. Available parameters are documented in Chapter 5, Server Configuration, in the documentation\&. .if n \{\ .sp .\} .RS 4 .it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1 .br .ps +1 \fBNote\fR .ps -1 .br If the parameter contains uppercase letters (e\&.g\&. delegate_IP), the parameter name must be enclosed in double quotes\&. .sp .5v .RE .RE .PP \fIconfiguration_parameter_group\fR .RS 4 The name of the Pgpool\-II configuration parameter group\&. Currently there are three parameter groups\&. .PP backend .RS 4 Configuration group of all backend config parameters\&. .RE .PP watchdog .RS 4 Configuration group of all watchdog node config parameters\&. .RE .PP heartbeat .RS 4 configuration group of all watchdog heartbeat config parameters\&. .RE .PP health_check .RS 4 configuration group of all health check parameters\&. .RE .RE .PP ALL .RS 4 Show the values of all configuration parameters, with descriptions\&. .RE .SH "EXAMPLES" .PP Show the current setting of the parameter port: .sp .if n \{\ .RS 4 .\} .nf PGPOOL SHOW port; port \-\-\-\-\-\- 9999 (1 row) .fi .if n \{\ .RE .\} .PP Show the current setting of the parameter write_function_list: .sp .if n \{\ .RS 4 .\} .nf PGPOOL SHOW write_function_list; write_function_list \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- nextval,setval (1 row) .fi .if n \{\ .RE .\} .PP Show the current settings of all the configuration parameters belonging to backend group: .sp .if n \{\ .RS 4 .\} .nf 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) .fi .if n \{\ .RE .\} .PP Show all settings: .sp .if n \{\ .RS 4 .\} .nf 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) .fi .if n \{\ .RE .\} .SH "SEE ALSO" PGPOOL SET (\fBPGPOOL_SET\fR(1)) .SH "NOTES" .IP " 1." 4 \fBSHOW\fR .RS 4 \%https://www.postgresql.org/docs/current/static/sql-show.html .RE