SHOW NODE
Displays configuration parameter values that are set for a node. If a configuration parameter is not set at the node level, SHOW NODE
does not return a row for that parameter. If the configuration parameter requires a restart to take effect, the values shown might differ from the active values.
Syntax
SHOW NODE node_name { parameter_name [,...]| ALL }
Parameters
node_name |
Name of node for which to show the parameter values. |
parameter_name |
Names of any configuration parameters you want to show. |
ALL |
Shows all configuration parameters that are set at the node level. |
Privileges
-
You must have superuser privileges to view some values. If you are not the superuser, and you use the the keyword 'ALL', parameter values are masked with ****. If the parameter is specifically listed, an error message appears.
- Non-superusers cannot view database or node-level security parameters.
Examples
The following example shows how display all values set for v_vmart_node0001
:
=> SHOW NODE v_vmart_node0001 ALL;
name | setting ------------------+--------- MaxClientSessions | 0 (1 row)