Re: md5 doesn't work (Was Re: Pet Peeves?) - Mailing list pgsql-general

From Bill Moran
Subject Re: md5 doesn't work (Was Re: Pet Peeves?)
Date
Msg-id 20090129145618.7e1a9cc9.wmoran@potentialtech.com
Whole thread Raw
In response to Re: md5 doesn't work (Was Re: Pet Peeves?)  (rhubbell <Rhubbell@iHubbell.com>)
List pgsql-general
In response to rhubbell <Rhubbell@iHubbell.com>:

> On Thu, 29 Jan 2009 11:34:00 -0800 (PST)
> Jeff Frost <jeff@frostconsultingllc.com> wrote:
>
> > On Thu, 29 Jan 2009, rhubbell wrote:
> >
> > > Umm, because md5 doesn't work and trust does work.
> >
> > Generally this is because you haven't yet set a password for the postgres
> > user.  You have to set a password for at least the postgres user via ALTER
> > ROLE while you've still got it set to trust or ident before changing to md5.
>
> Yeah, yeah, did all that, didn't work. Sorry, still a "Pet Peeve". (^;
> While you mention it, another "Pet Peeve" was the use of ident. Yikes.

_My_ point was that a broken md5 (which is still under debate) doesn't
force you to use trust.  There are other auth options like crypt and
password.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Mark Styles
Date:
Subject: Re: Changing owner of pg_toast tables
Next
From: Alan Hodgson
Date:
Subject: Re: md5 doesn't work (Was Re: Pet Peeves?)