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.
Name |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot