Re: SCRAM question - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: SCRAM question
Date
Msg-id 7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com
Whole thread Raw
In response to SCRAM question  (MichaelDBA <MichaelDBA@sqlexec.com>)
Responses Re: SCRAM question
List pgsql-performance
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/


JD


Regards,
Michael Vitale


-- 
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
***  A fault and talent of mine is to tell it exactly how it is.  ***
PostgreSQL centered full stack support, consulting and development. 
Advocate: @amplifypostgres || Learn: https://postgresconf.org
*****     Unless otherwise stated, opinions are my own.   *****

pgsql-performance by date:

Previous
From: MichaelDBA
Date:
Subject: SCRAM question
Next
From: Ulf Lohbrügge
Date:
Subject: Re: High CPU Usage of "SET ROLE"