Skip to main content
Version: 2.x

pg_file_settings

The pg_file_settings view provides a summary of the server's configuration files, showing each parameter's name, value, source file, line number, whether it was applied successfully, and any associated error messages. This view is useful for validating configuration changes and diagnosing issues in the configuration files.

nametypereferencesdescription
sourcefiletextFull path name of the configuration file.
sourcelineintegerLine number within the configuration file where the entry appears.
seqnointegerOrder in which the entries are processed (1..n).
nametextConfiguration parameter name.
settingtextValue to be assigned to the parameter.
appliedbooleanTrue if the value can be applied successfully.
errortextIf not null, an error message indicating why this entry could not be applied.