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_xc8aphs...@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(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers