Re: BUG #16695: pg_hba_file_rules NULL address and netmask

Apologies - please find screencaps and context at the following

- https://postgresteam.slack.com/archives/C0FS3UTAP/p1603440839348800
- https://topanswers.xyz/transcript?room=2&id=78663&year=2020&month=10#c78663

By way of description - IP address/netmask pairs given in pg_hba.conf are not read into the system view pg_hba_file_rules even in well formed and default installations. The shell commands given in the initial email are meant to give a minimum reproduction of this behavior when executed on FreeBSD 11

A default install on RHEL querying pg_hba_file_rules would show corresponding non-null values as appropriate

Kind regards

Peter Vandivier
Sent from my iPhone
Please excuse typos and brevity

On Nov 2, 2020, at 22:15, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> pg_hba_file_rules reports NULL address and netmask values incorrectly on
> FreeBSD 11 for tested postgres versions 10-13 (at least). e.g.

This is kind of an unhelpful bug report: you did not show what results
you got, nor what you expected to get.

regards, tom lane