public inbox for [email protected]  

help / color / mirror / Atom feed

From: James Cassell <[email protected]>
To: PostgreSQL Yum Package List <[email protected]>
Subject: Re: Can we stop defaulting to 'ident'?
Date: Thu, 19 Dec 2019 12:22:30 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAMsr+YFCuBGWh4=aM-K2LCsBEwcrqm=pphKKHEH09vHwXcspow@mail.gmail.com>
	<[email protected]>
	<[email protected]>


On Thu, Dec 19, 2019, at 11:57 AM, Stephen Frost wrote:
> Greetings,
> 
> * James Cassell wrote:
> > On Wed, Dec 18, 2019, at 11:58 PM, Craig Ringer wrote:
> > > 'ident' doesn't work by default on any RPM disto.
> > > 
> > > It's not clear why the initdb wrapper for the rpm packages defaults to 
> > > generating 'host' entries with 'ident' auth, but I think it's pretty 
> > > unhelpful. At least if we used 'md5' the user could set passwords and 
> > > have them actually work.
> > > 
> > >  initdbcmd="$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'"
> > >  initdbcmd+=" $PGSETUP_INITDB_OPTIONS"
> > > 
> > > I know you can override it easily enough, but most people won't know to.
> > 
> > For what it's worth, I am quite happy with the current default of ident.
> > 
> > To make it work, you can install the `authd` package, then enable the `auth.socket` systemd service.  I've made it listen only on localhost, and disabled the encryption part of authd because I didn't want to figure out how to give postgres the appropriate key.
> > 
> > All-in-all, it makes for a seamless auth of local users/services to their own postgres databases running on localhost.  Last I checked, ident auth was only specified for the localhost addreses in pg_hba.conf.  (RHEL 8 has marked the "authd" package as deprecated without any explanation, though... it still works fine and is still present.)
> 
> Why in the world would you want that over just using peer..?
> 

Peer does not work with TCP connections, and I haven't figured how to get,e.g., third-party Java applications working without TCP.

> 'host' with 'ident' should have been outright removed from PG, imv...  I
> actually thought it was but maybe it's only been deprecated.
> 

I guess I haven't paid close attention to deprecation notices. Was there a notice for it?

V/r,
James Cassell

view thread (54+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Can we stop defaulting to 'ident'?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox