pgsql: Invent pg_hba_file_rules view to show the content of pg_hba.conf

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(-)

Browse pgsql-committers by date

  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