shacrypt 1.0.0

This Release
shacrypt 1.0.0
Date
Status
Stable
Latest Stable
shacrypt 1.1.0 —
Other Releases
Abstract
Extension to hash passwords with SHA256-CRYPT and SHA512-CRYPT
Released By
dverite
License
PostgreSQL
Resources
Special Files
Tags

Extensions

shacrypt 1.0.0
Extension to manage scalable pseudo-random permutations of sequences

Documentation

LICENSE
Copyright and License

README

postgres-shacrypt

A PostgreSQL extension to generate SHA256-CRYPT and SHA512-CRYPT password hashes.

See https://www.akkadia.org/drepper/SHA-crypt.txt for the specification and upstream code by Ulrich Drepper.

Usage

 =# CREATE EXTENSION shacrypt;

 =# select sha256_crypt('clearpassword', 'somesalt');
           sha256_crypt                       
 ---------------------------------------------------------
  $5$somesalt$l3SlbI688JBlRS9RWFC1EwZLNJqfQKcrF3yhcbc7ffA

 =# select sha512_crypt('clearpassword', 'somesalt');
                     sha512_crypt                                            
 ----------------------------------------------------------------------------------------------------
  $6$somesalt$dDcgWMHOtvHI6qT/Khi3uaaxXN6v4N9bnOeWFl/Y6K3pzxi/zKEhE1dAdjBybsMrfO2FU8JpFJMkQipkTaiFO0

Functions

sha256_crypt(key text, salt text) RETURNS text

Generate SHA256-CRYPT hash for key with salt.

sha512_crypt(key text, salt text) RETURNS text

Generate SHA512-CRYPT hash for key with salt.

Installation

The Makefile uses the PGXS infrastructure to find include and library files, and determine the install location.
Build and install with:

$ make
$ (sudo) make install