Thread: Require entry of MD5 hash instead of plaintext password?

Is there a way to configure PostgreSQL 8.0 so that when prompted for a
password, the user enters the MD5 hash of his password, instead of the
normal plaintext password?

That is, when prompted for the password, instead of typing the
plaintext password as you normally would ("Foo", for example), you
would instead enter in the MD5 hash ("A8127A7CBLAHBLAHBLAHBLAH").

On Fri, Jul 27, 2007 at 09:33:37AM -0700, mwsenecal@yahoo.com wrote:
> Is there a way to configure PostgreSQL 8.0 so that when prompted for a
> password, the user enters the MD5 hash of his password, instead of the
> normal plaintext password?

What problem are you trying to solve?

--
Michael Fuhr

On Jul 28, 12:32 pm, m...@fuhr.org (Michael Fuhr) wrote:
> On Fri, Jul 27, 2007 at 09:33:37AM -0700, mwsene...@yahoo.com wrote:
> > Is there a way to configure PostgreSQL 8.0 so that when prompted for a
> > password, the user enters the MD5 hash of his password, instead of the
> > normal plaintext password?
>
> What problem are you trying to solve?
>
> --
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org/

Curiosity, mostly. When creating a user you can specify the password
as an MD5 hash. I was just wondering if you could also submit a
password in that form (the assumption being that a trusted external
application had performed the hashing).