Use md5 for postgres monitoring auth

'trust' over tcp is a headache and doesn't seem to work with pgsql.