pg_file_settings
The view pg_file_settings 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 a “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 current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.) By default, the pg_file_settings view can be read only by superusers.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- sourcefile, sourceline, seqno, name, setting, applied, error
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_file_settings 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 a “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 current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.) By default, the pg_file_settings view can be read only by superusers.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| sourcefile | text | Nullable | Full path name of the configuration file |
| sourceline | int4 | Nullable | Line number within the configuration file where the entry appears |
| seqno | int4 | Nullable | Order in which the entries are processed (1..n) |
| name | text | Nullable | Configuration parameter name |
| setting | text | Nullable | Value to be assigned to the parameter |
| applied | bool | Nullable | True if the value can be applied successfully |
| error | text | Nullable | If not null, an error message indicating why this entry could not be applied |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:86cee67e75c1c3616e715dc968c19597557cda1d96018995540aa00a91f9342d
Text language: en · catalog-bilingual-repair:86cee67e75c1c3616e715dc968c19597557cda1d96018995540aa00a91f9342d