Date: Tue, 11 Oct 2022 10:40:59 -0700
From: Nathan Bossart <nathandbossart@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
	Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Joe Conway <mail@joeconway.com>,
	Joshua Brindle <joshua.brindle@crunchydata.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: use has_privs_of_role() for pg_hba.conf
Message-ID: <20221011174059.GA1326442@nathanxps13>
References: <3347532.1665173939@sss.pgh.pa.us>
 <20221007215836.GB814385@nathanxps13>
 <87994809-5b2c-08f0-0ab3-3c76c49afada@joeconway.com>
 <3574712.1665242046@sss.pgh.pa.us>
 <CA+TgmoYDUpotJ3R5cPWqKZpi7TmTRq2ud4OYsvWnvPYK0KmaAQ@mail.gmail.com>
 <CAKFQuwbbR==cUhGpv0+G=z1mgKS+8ysdtMqSgt4mMvGwAyYYQg@mail.gmail.com>
 <20221008171222.GB825354@nathanxps13>
 <Y0Iht953YoGpCXeb@paquier.xyz>
 <20221009211348.GB900071@nathanxps13>
 <Y0T4kwYUobg09gPX@paquier.xyz>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Y0T4kwYUobg09gPX@paquier.xyz>
Archived-At: 
 <https://www.postgresql.org/message-id/20221011174059.GA1326442%40nathanxps13>
Precedence: bulk

On Tue, Oct 11, 2022 at 02:01:07PM +0900, Michael Paquier wrote:
> Thanks, applied.  It took me a few minutes to note that
> regress_regression_* is required in the object names because we need
> to use the same name for the parent role and the database, with
> "regress_" being required for the role and "regression" being required
> for the database.  I have added an extra section where pg_hba.conf is
> set to match only the parent role, while on it.  perltidy has reshaped
> things in an interesting way, because the generated log_[un]like is
> long, it seems.

Thanks!

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com