Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHYMR-0006iK-Ho for pgsql-performance@arkaria.postgresql.org; Tue, 30 Oct 2018 18:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHYMP-0000cd-JC for pgsql-performance@arkaria.postgresql.org; Tue, 30 Oct 2018 18:03:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHYMP-0000c8-83 for pgsql-performance@lists.postgresql.org; Tue, 30 Oct 2018 18:03:25 +0000 Received: from lists.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHYMM-0006Nl-2V for pgsql-performance@lists.postgresql.org; Tue, 30 Oct 2018 18:03:23 +0000 Received: from [192.168.50.9] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id AB3A37C7; Tue, 30 Oct 2018 11:03:15 -0700 (PDT) Received: from c-73-97-49-9.hsd1.wa.comcast.net ([73.97.49.9] helo=[192.168.50.9]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.5.1); 30 Oct 2018 11:03:15 -0700 Subject: Re: SCRAM question To: MichaelDBA , pgsql-performance@lists.postgresql.org References: <5BD89A3D.5060108@sqlexec.com> From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com> Date: Tue, 30 Oct 2018 11:03:14 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: <5BD89A3D.5060108@sqlexec.com> Content-Type: multipart/alternative; boundary="------------3DC31E156D92D6B76F5D1DCC" Content-Language: en-US X-Assp-Version: 2.5.1(16177) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-22595-10288 X-Assp-Session: 7F56E8634600 (mail 1) X-Assp-Original-Subject: Re: SCRAM question X-Assp-Client-SSL: yes List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------3DC31E156D92D6B76F5D1DCC Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit 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. ***** --------------3DC31E156D92D6B76F5D1DCC Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit
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.   *****
--------------3DC31E156D92D6B76F5D1DCC--