Mitch Vincent <mitch(at)doot(dot)org> writes:
> On the client side, am I responsible for making the password an MD5
> hash, or does libpq take care of that on it's own?
libpq does it. This is necessary, since the client shouldn't be
expected to know which way the password is to be encrypted on the wire.
The password given to libpq must always be cleartext.
> It seems that courier can only connect to the PG database when the auth
> type is set to crypt in the pg_hba.conf file. This is somewhat strange
I suspect it means that courier is linked to an old version of libpq.
regards, tom lane