pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Conway <mail@joeconway.com>
Cc: Joshua Brindle <joshua.brindle@crunchydata.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: use has_privs_of_role() for pg_hba.conf
Date: Tue, 11 Oct 2022 10:40:59 -0700
Message-ID: <20221011174059.GA1326442@nathanxps13> (raw)
In-Reply-To: <Y0T4kwYUobg09gPX@paquier.xyz>
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>

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





view thread (25+ messages)  latest in thread

Message-ID: <20221011174059.GA1326442@nathanxps13>
Permalink:  ../20221011174059.GA1326442@nathanxps13/
Also on:    postgresql.org/message-id/20221011174059.GA1326442@nathanxps13

 · 

reply
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-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, michael@paquier.xyz, david.g.johnston@gmail.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, mail@joeconway.com, joshua.brindle@crunchydata.com
  Subject: Re: use has_privs_of_role() for pg_hba.conf
  In-Reply-To: <20221011174059.GA1326442@nathanxps13>

* 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