Re: MD5 Passwords and user administratio

Thanx.  Actually, it was a version problem.  Was using 7.2 and it did not do
that automatically.  Spent some time and installed 7.3 from source yesterday.

Thanx for the help

Carlos

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Carlos Ortiz <ortizc2@yahoo.com> writes:
> > I am trying to figure out exactly how to set someone's password when
> > using MD5 passwords in postgres.
>
> ALTER USER joe WITH PASSWORD 'secret';
>
> > What exactly is psotgres passing to the MD5 hash to make up that
> > incredible unintelligible stream of characters that it stores in the
> > password field of the pg_shadow table?
>
> I think the salt is the username --- but you shouldn't write code that
> depends on knowing that.  None of the MD5 behavior is considered
> user-visible.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com