pg_shadow and pgcrypto - Mailing list pgsql-general

From Frank Cavaliero
Subject pg_shadow and pgcrypto
Date
Msg-id OF4FB30822.73058640-ON85257ACA.00729BE9-85257ACA.0072A999@us.ibm.com
Whole thread Raw
List pgsql-general
Hi all,

I'm currently performing a hash check for password verification.    I'm generating an md5  hash or checking for plain text in pg_shadow.  However, outside of these two "out-of-the-box" options, what if someone is using pg-crypto or any other PAM ?  How can I differentiate between say md5 and pgcrypto ?  I see the md5 is prefixed in hash in pg_shadow.  I was wondering what other prefixes may exist, say for pgcrypto.  If you have an examples of what a pgcrypto or any other PAM hash would look like (or what they would at least begin with), that would be great.

Thanks,
Frank





Frank Cavaliero

Database Administrator

IBM Infosphere Guardium

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Which is faster: char(14) or varchar(14)
Next
From: Edson Richter
Date:
Subject: Re: Which is faster: char(14) or varchar(14)