Hoa Phan <s50600822@xxxxxxxxx> 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