Postgres Pro
Downloads
Home   >   mailing lists

Re: Authentication: MD5 to SCRAM-SHA-256 error - Mailing list pgsql-general

From Dave Hughes
Subject Re: Authentication: MD5 to SCRAM-SHA-256 error
Date
Msg-id CAFTBbFDAJXKF5PNJASfEhfDOhMdHqV7Fn_jWhF8Q2_Ey-cr1nQ@mail.gmail.com
Whole thread Raw
In response to Re: Authentication: MD5 to SCRAM-SHA-256 error  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Responses Re: Authentication: MD5 to SCRAM-SHA-256 error  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Tree view
Thanks for replying guys!  You both led me down the right path.  I didn't realize it, but looks like we had 2 directories where psql was installed.  Once I gave the path specifically to PostgreSQL10, it worked like a charm. 

I'm reaching out to our server admins now to see why there are 2 instances.  

Thanks again for pointing me in the right direction. 

On Fri, Nov 15, 2019 at 11:44 AM Christoph Moench-Tegeder <cmt@burggraben.net> wrote:
## Dave Hughes (dhughes20@gmail.com):

> However when I try to log in now, via command line, I receive the error:
> "psql: authentication method 10 not supported".

Your client (more precisely: it's libpq) is not ready for SCRAM.
I guess you're using an older (<10) client version? Mixed up
packages?

Regards,
Christoph

--
Spare Space

pgsql-general by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: jsonb_set() strictness considered harmful to data
Next
From: Thomas Munro
Date:
Subject: Re: here does postgres take its timezone information from?