Re: [ADMIN] How To Change Password Hash Algorithm From MD5 to SHA-256

2012-06-08 Thread Josh Kupershmidt
On Thu, Jun 7, 2012 at 8:12 AM, ROMAIN, ERICKA W CTR DISA PEO-MA wrote: > I am trying to get Postgres to use SHA as the password hash algorithm instead > of MD5. This is a security requirement. I am running PostgreSQL 8.4 on a Red > Hat Linux platform. I have installed pgcrypto and ran pgcrypto.

[ADMIN] How To Change Password Hash Algorithm From MD5 to SHA-256

2012-06-08 Thread ROMAIN, ERICKA W CTR DISA PEO-MA
I am trying to get Postgres to use SHA as the password hash algorithm instead of MD5. This is a security requirement. I am running PostgreSQL 8.4 on a Red Hat Linux platform. I have installed pgcrypto and ran pgcrypto.sql. I also created a function SHA-256. The function looks like: CREATE OR RE