Postgres Pro
Downloads
Home   >   mailing lists

Thread: Encrypted role password

Encrypted role password

From
Mark Watson
Date:

Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson

 

Re: Encrypted role password

From
Melvin Davidson
Date:
I am not pgadmin support, but if you are a superuser,
you can get the password with:

SELECT rolname,
       rolpassword
  FROM pg_authid
WHERE rolname = 'username';





Melvin Davidson 🎸
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark.watson@jurisconcept.ca> wrote:


Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson

 

RE: Encrypted role password

From
Mark Watson
Date:

De : Melvin Davidson [mailto:melvin6925@yahoo.com]

 

I am not pgadmin support, but if you are a superuser,

you can get the password with:

 

SELECT rolname,
       rolpassword
  FROM pg_authid
WHERE rolname = 'username';

-----------------------------------

Thanks, Melvin

It’s also available in pg_shadow. I was just having a lazy day :)

 

 

On Friday, September 29, 2017, 10:21:58 AM EDT, Mark Watson <mark.watson@jurisconcept.ca> wrote:

 

 

Good day all,

First of all, thank you for the good work with pgAdmin4.

My question is, in pgAdmin3, the SQL pane for the role create script shows the md5 encrypted password. Are there any plans to display this for pgAdmin4 ?

 

Mark Watson