Postgres Pro
Downloads
Home   >   mailing lists

Re: create user xxx with md5 string? - Mailing list pgsql-sql

From Tom Lane
Subject Re: create user xxx with md5 string?
Date
Msg-id 12517.1259868079@sss.pgh.pa.us
Whole thread Raw
In response to create user xxx with md5 string?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: create user xxx with md5 string?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: create user xxx with md5 string?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
Tree view 
Gerardo Herzig <gherzig@fmed.uba.ar> writes:
> Hi all. Im triyng, with no success, to create a user, and set the
> password with a md5 string.

The correct method for computing the md5'd password includes the
username.  I think it's 'md5' || md5sum(password || username)
but look at the code or docs.
        regards, tom lane

pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: create user xxx with md5 string?
Next
From: Dmitriy Igrishin
Date:
Subject: Re: create user xxx with md5 string?