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.