Обсуждение: pgsql: Add pg_file_settings view and function
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(+)
On 2015-05-08 23:09:42 +0000, Stephen Frost wrote: > Add pg_file_settings view and function > 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(+) Hm. Catversion bump missing?
* Andres Freund (andres@anarazel.de) wrote:
> On 2015-05-08 23:09:42 +0000, Stephen Frost wrote:
> > Add pg_file_settings view and function
> > 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(+)
>
> Hm. Catversion bump missing?
Argh. Yes. Will fix.
Thanks!
Stephen