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. *****