Обсуждение: login role password
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
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
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;
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