Postgres Pro
Downloads
Home   >   mailing lists

Re: login role password - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: login role password
Date
Msg-id CAGCvxea85Ve3RPvGSUtbdOU4ubDeQqV1rGJzBfEP5_ZGdSc0mQ@mail.gmail.com
Whole thread Raw
In response to Re: login role password  (Isaías Sánchez <isaias.sanchez.l@gmail.com>)
List pgadmin-support
Tree view
Thanks.  That is a helpful workaround.

I am asking for this functionality to be added to PgAdmin4, so that when you select the SQL for a login role you see what PgAdmin3 shows.

  CREATE ROLE xxx_user LOGIN
    ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09'
    SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;

And that the dialog for a login user supports setting an encrypted password.

I know I can run this in an SQL window:

  ALTER ROLE xxx_user ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09';

but it would be nice if PgAdmin4 supported this in the GUI

On Tue, Jun 4, 2019 at 8:40 AM Isaías Sánchez <isaias.sanchez.l@gmail.com> wrote:
Just: select * from pg_authid;

En 4 de junio de 2019 15:14:49 Michael Shapiro <mshapiro51@gmail.com> escribió:

PgAdmin3 has the ability to see the encrypted password for a login role. That allow me to copy the login role password from one server to another (without having to know the password). 

I don't see how to see the encrypted password for a login role in PgAdmin4


pgadmin-support by date:

Previous
From: Isaías Sánchez
Date:
Subject: Re: login role password
Next
From: Michelle Schwan
Date:
Subject: pgAdmin IV