From: Peter Vandivier <petervandivier@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16695: pg_hba_file_rules NULL address and netmask
Date: Mon, 2 Nov 2020 22:26:25 +0000
Message-ID: <258C6CBF-BF3B-4042-B1E2-EC67634C17A0@gmail.com> (raw)
In-Reply-To: <826464.1604355302@sss.pgh.pa.us>
References: <826464.1604355302@sss.pgh.pa.us>
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@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: petervandivier@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16695: pg_hba_file_rules NULL address and netmask
In-Reply-To: <258C6CBF-BF3B-4042-B1E2-EC67634C17A0@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox