From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hoa Phan <s50600822@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: How to create a postgres user that auth by AUTH_REQ_MD5
Date: Thu, 09 May 2019 10:03:04 -0400
Message-ID: <3202.1557410584@sss.pgh.pa.us> (raw)
In-Reply-To: <CAAaXBY1a03DNi4fpr9hLB5zERyjfF2i3EZKpvwikQM1xcHxSHg@mail.gmail.com>
References: <CAAaXBY1a03DNi4fpr9hLB5zERyjfF2i3EZKpvwikQM1xcHxSHg@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, s50600822@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to create a postgres user that auth by AUTH_REQ_MD5
In-Reply-To: <3202.1557410584@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox