| From: | Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_shadow and pgcrypto |
| Date: | 2012-12-04 20:50:36 |
| Message-ID: | OF4FB30822.73058640-ON85257ACA.00729BE9-85257ACA.0072A999@us.ibm.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2012-12-04 21:09:16 | Re: Which is faster: char(14) or varchar(14) |
| Previous Message | Sergey Konoplev | 2012-12-04 20:49:15 | Re: Which is faster: char(14) or varchar(14) |