Hoa Phan <s50600822@gmail.com> writes:
> How do I create user that required AUTH_REQ_MD5 or config database so that
> it require AUTH_REQ_MD5 ?
That's determined by your pg_hba.conf rules. If you really want to
have just one user acting that way, you can use a rule that keys on
user name; but it's an unusual thing to do I think.
https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
regards, tom lane