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 <[EMAIL PROTECTED]> wrote: > Carlos Ortiz <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
