Re: Password encryption

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Password encryption
Date: 2018-04-16 01:16:04
Message-ID: b2d67a07-4766-ac8c-8445-79aae8bea572@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message TSG 2018-04-16 02:20:11 How to tell if PGSQL 8.4 is in standby mode
Previous Message Adrian Klaver 2018-04-16 00:37:33 Re: Password encryption

Browse pgsql-general by date

  From Date Subject
Next Message armand pirvu 2018-04-16 01:22:03 Re: authentication failure
Previous Message Adrian Klaver 2018-04-16 00:37:33 Re: Password encryption