PGXC_SETTINGS
PGXC_SETTINGS displays the database running status of each node in the cluster. All columns except node_name are the same as those in the PG_SETTINGS view. This view is accessible only to users with system administrators rights.
| Column | Type | Description |
|---|---|---|
| node_name | Text | Node name |
| Name | Text | Parameter name |
| setting | Text | Current value of the parameter |
| unit | Text | Implicit unit of the parameter |
| category | Text | Logical group of the parameter |
| short_desc | Text | Brief description of the parameter |
| extra_desc | Text | Detailed description of the parameter |
| context | Text | Context of parameter values including internal, postmaster, sighup, backend, superuser, and user. |
| vartype | Text | Parameter type. It can be bool, enum, integer, real, or string. |
| source | Text | Method of assigning the parameter value |
| min_val | Text | Minimum value of the parameter If the parameter type is not numeric data, the value of this column is null. |
| max_val | Text | Maximum value of the parameter. If the parameter type is not numeric data, the value of this column is null. |
| enumvals | Text[] | Valid values of an enum-typed parameter. If the parameter type is not enum, the value of this column is null. |
| boot_val | Text | Default parameter value used upon the database startup |
| reset_val | Text | Default parameter value used upon the database reset |
| sourcefile | Text | Configuration file used to set parameter values. If parameter values are not configured using the configuration file, the value of this column is null. |
| sourceline | Integer | Row number of the configuration file for setting parameter values. If parameter values are not configured using the configuration file, the value of this column is null. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
