Re: create user xxx with md5 string?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: create user xxx with md5 string?
Date: 2009-12-03 19:21:19
Message-ID: 12517.1259868079@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitriy Igrishin 2009-12-03 19:36:58 Re: create user xxx with md5 string?
Previous Message Gerardo Herzig 2009-12-03 19:02:58 Re: create user xxx with md5 string?