Re: Disabling trust/ident authentication configure option - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Disabling trust/ident authentication configure option
Date
Msg-id 20150520215444.GR27868@alap3.anarazel.de
Whole thread Raw
In response to Re: Disabling trust/ident authentication configure option  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Disabling trust/ident authentication configure option  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Disabling trust/ident authentication configure option  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 2015-05-20 15:42:23 -0400, Stephen Frost wrote:
> > So the first thing to establish is "other than Volker himself, who are
> > we helping here?"
> 
> I don't agree with this either.  Providing a "bypass all authentication"
> configuration option really isn't a good thing.  Why don't packagers use
> our default pg_hba.conf?  Because it only makes sense in a development
> type of environment.  I'd argue the same is true for 'trust'.

Uh. So if the shit hit the fan because you mismanaged a password
rollover, kereberos is down, or something like that, and you can't
access postgres anymore you want to recompile? And no peer isn't an
answer isn't an answer, it's not available on windows. Your only way out
is going to be single user mode. But wait, that's a security hole too.


I find the arguments presented in this thread for a configure option
entirely unconvincing. If you'd argued for a saner default
authentication setup: I'd be on board with that. But this seems just a
pointless exercise in making things more complicated.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling trust/ident authentication configure option
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.