Re: pgadmin4 2.0 and Scram

On Sat, Oct 7, 2017 at 4:48 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

> Since pgAdmin4 2.0 is targetting v10 of PostgreSQL, I thought it would
> support scram authentication in addition to md5. In fact, I thought this
> would happen automatically simply by virtue of using the latest libpq.dll,
> without any coding changes to pgAdmin4 itself.
>
> But when I set myself a scram-hashed password (using psql) and then try to
> connect with pgAdmin4, I get the message "authentication method 10 not
> supported", which is the message you get from pre-v10 versions of libpq.
>
> Is this a known issue? Does the installer include the wrong libpq.dll?
>
pgAdmin4 uses psycopg2 <http://initd.org/psycopg/docs/> in order to
communicate with Postgres and psycopg2 is lacking support for Scram at a
moment, and I think developers are already working on adding support for
PG10 (https://github.com/psycopg/psycopg2/pull/576)

>
> Cheers,
>
> Jeff
>