pg_shadow and pgcrypto

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: Raw Message | Whole Thread | 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

Browse pgsql-general by date

  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)