Re: How to create a postgres user that auth by AUTH_REQ_MD5 - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to create a postgres user that auth by AUTH_REQ_MD5
Date
Msg-id 3202.1557410584@sss.pgh.pa.us
Whole thread Raw
In response to How to create a postgres user that auth by AUTH_REQ_MD5  (Hoa Phan <s50600822@gmail.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: pg_receivewal configuration issues
Next
From: Rui DeSousa
Date:
Subject: Re: postgres wal log configuration question