pgsql: Add pg_file_settings view and function

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add pg_file_settings view and function
Date: 2015-05-08 23:09:42
Message-ID: E1YqrOo-0005ag-Rl@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add pg_file_settings view and function

The function and view added here provide a way to look at all settings
in postgresql.conf, any #include'd files, and postgresql.auto.conf
(which is what backs the ALTER SYSTEM command).

The information returned includes the configuration file name, line
number in that file, sequence number indicating when the parameter is
loaded (useful to see if it is later masked by another definition of the
same parameter), parameter name, and what it is set to at that point.
This information is updated on reload of the server.

This is unfiltered, privileged, information and therefore access is
restricted to superusers through the GRANT system.

Author: Sawada Masahiko, various improvements by me.
Reviewers: David Steele

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/a97e0c3354ace5d74c6873cd5e98444757590be8

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 78 ++++++++++++++++++++++
src/backend/catalog/system_views.sql | 6 ++
src/backend/utils/misc/guc-file.l | 50 ++++++++++++++
src/backend/utils/misc/guc.c | 120 ++++++++++++++++++++++++++++++++++
src/include/catalog/pg_proc.h | 2 +
src/include/utils/builtins.h | 1 +
src/test/regress/expected/rules.out | 6 ++
7 files changed, 263 insertions(+)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2015-05-08 23:12:53 Re: pgsql: Add pg_file_settings view and function
Previous Message Andres Freund 2015-05-08 20:28:56 pgsql: Fix two problems in infer_arbiter_indexes().