"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> Check the syntax for the alter user statement, whereever it says you may use
> the word ENCRYPTED use it and you should then be able to use 'crypt' in the
> pg_hba.conf.
Actually I think this advice is backwards. If you want to use crypt
authentication mode then you have to store *unencrypted* passwords in
pg_shadow, because encrypted passwords will be stored using MD5
encryption which is not compatible with crypt-style encryption.
But probably better advice is "don't use crypt auth mode, use md5".
The crypt mode is only still there to support legacy clients that
haven't been updated to handle md5 yet.
regards, tom lane
