| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, Scott Mead <scottm(at)openscg(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_hba_lookup function to get all matching pg_hba.conf entries |
| Date: | 2016-07-11 02:05:47 |
| Message-ID: | CAJrrPGfmphnHyxiAuoZdENCJyHVgwc9VhYqZmWjkWY5AU8P19g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Apr 9, 2016 at 6:36 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> More generally, I'm not convinced about the use-case for this patch.
> What problem is it supposed to help in dealing with, exactly? Not syntax
> errors in the hba file, evidently, since it doesn't make any attempt to
> instrument the file parser. And it's not very clear that it'll help
> with "I can't connect", either, because if you can't connect you're
> not going to be running this function.
Apologies for replying an old thread.
The main reason behind of this patch is for the administrators to control
and verify the authentication mechanism that was deployed for several
users in the database is correctly picking the assigned hba config or not?
I feel this SQL function is useful for administrators and not for normal
users.
If anyone is not against to the above use case, i will update the patch based
on the review comments and post it later.
Regards,
Hari Babu
Fujitsu Australia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Etsuro Fujita | 2016-07-11 02:40:23 | Re: doc: Incorrect return type of IsForeignScanParallelSafe in fdwhandler.sgml |
| Previous Message | Tom Lane | 2016-07-10 23:34:15 | Re: can we optimize STACK_DEPTH_SLOP |