provides a summary of
the contents of the server's configuration file(s). A row appears in
this view for each
name = value
entry appearing in the files,
with annotations indicating whether the value could be applied
successfully. Additional row(s) may appear for problems not linked to
name = value
entry, such as syntax errors in the files.
This view is helpful for checking whether planned changes in the
configuration files will work, or for diagnosing a previous failure.
Note that this view reports on the
contents of the
files, not on what was last applied by the server. (The
view is usually sufficient to determine that.)
By default, the
view can be read
only by superusers.
Full path name of the configuration file
Line number within the configuration file where the entry appears
Order in which the entries are processed (1..
Configuration parameter name
Value to be assigned to the parameter
True if the value can be applied successfully
If not null, an error message indicating why this entry could not be applied
If the configuration file contains syntax errors or invalid parameter
names, the server will not attempt to apply any settings from it, and
therefore all the
fields will read as false.
In such a case there will be one or more rows with
fields indicating the
problem(s). Otherwise, individual settings will be applied if possible.
If an individual setting cannot be applied (e.g., invalid value, or the
setting cannot be changed after server start) it will have an appropriate
message in the
field. Another way that
an entry might have
= false is that it is
overridden by a later entry for the same parameter name; this case is not
considered an error so nothing appears in
See Section 19.1 for more information about the various ways to change run-time parameters.