* Andrew Dunstan (andrew(at)dunslane(dot)net) wrote:
> The docs say: "only md5 supports encrypted passwords stored in
> pg_shadow; the other two require unencrypted passwords to be stored
> there." So either your assertion that 'password' auth does not imply
> plaintext password storage is wrong, or the docs are.
The docs are wrong. Sorry, I knew that and forgot to mention it
explicitly previously. Using 'password' in pg_hba.conf while using
'with encrypted password'/md5 in pg_shadow works just fine.
Just tested here to make 100% sure, under 8.0.1.
Thanks,
Stephen