Skip to content

Collecting applied or not applied settings #118

@cherts

Description

@cherts

Is your feature request related to a problem? Please describe.
It is necessary to collect data on whether all configuration settings have been applied or whether some are pending applied.

Describe the solution you'd like
It is necessary to implement collection of additional data in the postgres/settings collector by query:

SELECT sourcefile, COUNT(*), 
(CASE applied WHEN 't' THEN 'true' ELSE 'false' END) as applied 
FROM pg_file_settings GROUP BY sourcefile, applied;

Example of result:

+-------------------------------------------+-------+---------+
|                sourcefile                 | count | applied |
+-------------------------------------------+-------+---------+
| /etc/postgresql/17/main/conf.d/test2.conf |     1 | true    |
| /etc/postgresql/17/main/postgresql.conf   |    26 | true    |
| /etc/postgresql/17/main/conf.d/test1.conf |     1 | true    |
| /etc/postgresql/17/main/conf.d/test3.conf |     1 | false   |
+-------------------------------------------+-------+---------+
(4 rows)

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions