Re: encrypted passwords

>>
>> I cannot set up password authentication with encrypted passwords.
>> With  plaintext passwords auth works fine. So my guess is that I am
>> using an  incorrect password encryption program.
>>
>> What encryption utility should I use to store an MD5 password?
>>
>> I tried md5sum, but passwords encrypted with md5sum will not let me
>> log in.
>>
>> I also tried classic "crypt", and I used Python's crypt module to
>> encrypt my password, and it did not work either.
>
> You don't manually encrypt them with anything.  You enter them
> plain-text and pgsql encrypts them before storage.
>

But, FWIW, someone else in an earlier thread posted that what gets stored
in the passwd column of pg_shadow is the value returned by

select 'md5'||encode(digest('your_password'||'your_username' , 'md5'),
'hex')


--Berend Tober