From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Invent pg_hba_file_rules view to show the content of pg_hba.conf |
Date: | 2017-01-30 23:00:34 |
Message-ID: | E1cYKw6-0005Mw-O3@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Invent pg_hba_file_rules view to show the content of pg_hba.conf.
This view is designed along the same lines as pg_file_settings, to wit
it shows what is currently in the file, not what the postmaster has
loaded as the active settings. That allows it to be used to pre-vet
edits before issuing SIGHUP. As with the earlier view, go out of our
way to allow errors in the file to be reflected in the view, to assist
that use-case.
(We might at some point invent a view to show the current active settings,
but this is not that patch; and it's not trivial to do.)
Haribabu Kommi, reviewed by Ashutosh Bapat, Michael Paquier, Simon Riggs,
and myself
Discussion: https://postgr.es/m/CAJrrPGerH4jiwpcXT1-46QXUDmNp2QDrG9+-Tek_xC8APHShYw@mail.gmail.com
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/de16ab7238888b16825ad13f0bbe123632915e9b
Modified Files
--------------
doc/src/sgml/catalogs.sgml | 113 +++++
doc/src/sgml/client-auth.sgml | 18 +
src/backend/catalog/system_views.sql | 6 +
src/backend/libpq/hba.c | 824 ++++++++++++++++++++++++++++-----
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 2 +
src/include/libpq/hba.h | 9 +-
src/test/regress/expected/rules.out | 10 +
src/test/regress/expected/sysviews.out | 7 +
src/test/regress/sql/sysviews.sql | 3 +
10 files changed, 873 insertions(+), 121 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-01-30 23:42:47 | pgsql: Simplify some long-obsolete code in hba.c's next_token(). |
Previous Message | Tom Lane | 2017-01-30 22:15:52 | pgsql: Add a regression test script dedicated to exercising system view |