pg_shadow and pg_crypto

From: Frank Cavaliero <fcavalie(at)us(dot)ibm(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_shadow and pg_crypto
Date: 2012-12-04 20:49:53
Message-ID: OF67E6F379.E07ECAB7-ON85257ACA.0071EB0D-85257ACA.00729867@us.ibm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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-admin by date

  From Date Subject
Next Message teyking2003 2012-12-05 00:48:34 Re: Cronjob to autobackup database
Previous Message Spike Grobstein 2012-12-04 14:51:32 Re: Cronjob to autobackup database