Re: Password encryption - Mailing list pgsql-admin

From Ron
Subject Re: Password encryption
Date
Msg-id b2d67a07-4766-ac8c-8445-79aae8bea572@gmail.com
Whole thread Raw
In response to Password encryption  (Azimuddin Mohammed <azimeiu@gmail.com>)
List pgsql-admin
On 04/15/2018 07:22 PM, Azimuddin Mohammed wrote:
Hello,
Is there a way I can encrypt the default password column of db user password. I know by default the password is encrypted as md5, can we encrypt that of shadow column for password?

MD5 is a one-way hash, not an encryption scheme.  Thus, the password cannot be reverse-computed from the MD5 hash value.  So, you're (kinda) safe, although an attacker could determine the password through brute-force calculation of hashes.


--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Password encryption
Next
From: "TSG"
Date:
Subject: How to tell if PGSQL 8.4 is in standby mode