Now I would like to also be able to verify a user password with Postgresql and pgcrypto. But pgcrypto'scrypt()function is not able to verify the existing password hashes. However - I can verify password hashes generated by Postgresql with PHP'spassword_verify. For example: password_hash(...
你可以使用Postgres.app来做你需要做的事情,这是在Mac上运行多个版本的postgresql的好方法。
NOTE:if you are already using a PostgreSQL-descendant as an adapter (for example, the awesomePostGIS adapter), you'll need to read through the "Alternate Adapters" section below. Butdon't panic, it's 100% supported by PGCrypto. Generate the required files using the included generator. ...