From: Michael Paquier <michael@paquier.xyz>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: SCRAM question
Date: Wed, 31 Oct 2018 18:55:01 +0900
Message-ID: <20181031095501.GH7862@paquier.xyz> (raw)
In-Reply-To: <7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com>
References: <5BD89A3D.5060108@sqlexec.com>
<7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com>
On Tue, Oct 30, 2018 at 11:03:14AM -0700, Joshua D. Drake wrote:
> On 10/30/18 10:51 AM, MichaelDBA wrote:
>> I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I
>> try to connect with scram authorization:
>>
>> User "myuser" does not have a valid SCRAM verifier.
>>
>> How do I get around this? And also how would I do this for psql?
>
> You need to update the password using SCRAM I believe...
>
> |See here:
> https://paquier.xyz/postgresql-2/postgres-10-scram-authentication/|
In order to do that, you would basically need to:
1) Switch password_encryption to 'scram-sha-256' in the server
configuration.
2) Issue an ALTER ROLE command to update the password (likely it is
better to use \password from psql as this would send a hashed password
to the server, which relies on the server setting for
password_encryption).
3) Make sure that pg_hba.conf is using properly scram-sha-256 where it
should as authentication method.
If you do not want to upgrade to SCRAM, it is of course possible to
still remain with md5.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../20181031095501.GH7862@paquier.xyz/2-signature.asc)
download
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-performance@postgresql.org
Cc: michael@paquier.xyz, jd@commandprompt.com, MichaelDBA@sqlexec.com, pgsql-performance@lists.postgresql.org
Subject: Re: SCRAM question
In-Reply-To: <20181031095501.GH7862@paquier.xyz>
* 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