Extensions
shacrypt

shacrypt

shacrypt : Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

Overview

ID Extension Package Version Category License Language
4440
shacrypt
shacrypt
 1.1
UTIL
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
hashlib
xxhash
cryptint
pguecc
pgcrypto
gzip
bzip
zstd

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 1.1
18
17
16
15
14
 shacrypt -
RPM
PIGSTY
 1.1
18
17
16
15
14
 shacrypt_$v -
DEB
PIGSTY
 1.1
18
17
16
15
14
 postgresql-$v-shacrypt -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
el8.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
el9.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
el9.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
el10.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
el10.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
d12.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
d12.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
d13.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
d13.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
u22.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
u22.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
u24.x86_64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
u24.aarch64
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
PIGSTY 1.1
Package Version OS ORG SIZE File URL
shacrypt_18 1.1 el8.x86_64 pigsty 19.7 KiB shacrypt_18-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_18 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_18-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_18 1.1 el9.x86_64 pigsty 18.9 KiB shacrypt_18-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_18 1.1 el9.aarch64 pigsty 18.7 KiB shacrypt_18-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_18 1.1 el10.x86_64 pigsty 18.6 KiB shacrypt_18-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_18 1.1 el10.aarch64 pigsty 18.6 KiB shacrypt_18-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-18-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-18-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-18-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-18-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-18-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-18-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-18-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-18-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-18-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-18-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-18-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-18-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-18-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-18-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-18-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-18-shacrypt_1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
shacrypt_17 1.1 el8.x86_64 pigsty 19.7 KiB shacrypt_17-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_17 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_17-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_17 1.1 el9.x86_64 pigsty 18.9 KiB shacrypt_17-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_17 1.1 el9.aarch64 pigsty 18.7 KiB shacrypt_17-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_17 1.1 el10.x86_64 pigsty 18.6 KiB shacrypt_17-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_17 1.1 el10.aarch64 pigsty 18.5 KiB shacrypt_17-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-17-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-17-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-17-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-17-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-17-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-17-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-17-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-17-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-17-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-17-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-17-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-17-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-17-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-17-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-17-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-17-shacrypt_1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
shacrypt_16 1.1 el8.x86_64 pigsty 19.7 KiB shacrypt_16-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_16 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_16-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_16 1.1 el9.x86_64 pigsty 18.9 KiB shacrypt_16-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_16 1.1 el9.aarch64 pigsty 18.7 KiB shacrypt_16-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_16 1.1 el10.x86_64 pigsty 18.6 KiB shacrypt_16-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_16 1.1 el10.aarch64 pigsty 18.6 KiB shacrypt_16-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-16-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-16-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-16-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-16-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-16-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-16-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-16-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-16-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-16-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-16-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-16-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-16-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-16-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-16-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-16-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-16-shacrypt_1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
shacrypt_15 1.1 el8.x86_64 pigsty 19.8 KiB shacrypt_15-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_15 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_15-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_15 1.1 el9.x86_64 pigsty 19.2 KiB shacrypt_15-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_15 1.1 el9.aarch64 pigsty 19.1 KiB shacrypt_15-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_15 1.1 el10.x86_64 pigsty 18.9 KiB shacrypt_15-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_15 1.1 el10.aarch64 pigsty 18.9 KiB shacrypt_15-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-15-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-15-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-15-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-15-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-15-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-15-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-15-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-15-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-15-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-15-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-15-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-15-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-15-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-15-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-15-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-15-shacrypt_1.1-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
shacrypt_14 1.1 el8.x86_64 pigsty 19.8 KiB shacrypt_14-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_14 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_14-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_14 1.1 el9.x86_64 pigsty 19.2 KiB shacrypt_14-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_14 1.1 el9.aarch64 pigsty 19.1 KiB shacrypt_14-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_14 1.1 el10.x86_64 pigsty 18.9 KiB shacrypt_14-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_14 1.1 el10.aarch64 pigsty 18.9 KiB shacrypt_14-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-14-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-14-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-14-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-14-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-14-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-14-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-14-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-14-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-14-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-14-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-14-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-14-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-14-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-14-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-14-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-14-shacrypt_1.1-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/dverite/postgres-shacrypt
 Source Tarball
postgres_shacrypt-1.1.tar.gz
 
pig build pkg shacrypt;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install shacrypt;		# install via package name, for the active PG version

pig install shacrypt -v 18;   # install for PG 18
pig install shacrypt -v 17;   # install for PG 17
pig install shacrypt -v 16;   # install for PG 16
pig install shacrypt -v 15;   # install for PG 15
pig install shacrypt -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION shacrypt;

Usage

shacrypt: SHA-crypt password hashing for PostgreSQL

Generate SHA256-CRYPT and SHA512-CRYPT password hashes per the SHA-crypt specification.

Functions

sha256_crypt(key text, salt text) RETURNS text 

SELECT sha256_crypt('clearpassword', 'somesalt');
-- $5$somesalt$l3SlbI688JBlRS9RWFC1EwZLNJqfQKcrF3yhcbc7ffA

With custom rounds:

SELECT sha256_crypt('clearpassword', '$5$rounds=10000$somesalt');
-- $5$rounds=10000$somesalt$OekH6Tu7EOJIAvxKJ4Ko4bG0DxgO83gZODJLTTjXJi5

sha512_crypt(key text, salt text) RETURNS text 

SELECT sha512_crypt('clearpassword', 'somesalt');
-- $6$somesalt$dDcgWMHOtvHI6qT/Khi3uaaxXN6v4N9bnOeWFl/Y6K3pzxi/...

Salt Format

  • Simple salt: 'somesalt'
  • With algorithm prefix: '$5$somesalt' (SHA-256) or '$6$somesalt' (SHA-512)
  • With custom rounds: '$5$rounds=10000$somesalt'
Last updated on
xxhashcryptint