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.
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