跳转到主要内容

shacrypt

Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes

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 pgsodium pgcrypto pguecc cryptint pgcryptokey pgsmcrypto hashlib xxhash md5hash hashtypes

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
u26.x86_64 PIGSTY 1.1 PIGSTY 1.1 PIGSTY 1.1 PIGSTY 1.1 PIGSTY 1.1
u26.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
postgresql-18-shacrypt 1.1 u26.x86_64 pigsty 32.0 KiB postgresql-18-shacrypt_1.1-1PIGSTY~resolute_amd64.deb
postgresql-18-shacrypt 1.1 u26.aarch64 pigsty 31.4 KiB postgresql-18-shacrypt_1.1-1PIGSTY~resolute_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
postgresql-17-shacrypt 1.1 u26.x86_64 pigsty 32.0 KiB postgresql-17-shacrypt_1.1-1PIGSTY~resolute_amd64.deb
postgresql-17-shacrypt 1.1 u26.aarch64 pigsty 31.4 KiB postgresql-17-shacrypt_1.1-1PIGSTY~resolute_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
postgresql-16-shacrypt 1.1 u26.x86_64 pigsty 32.0 KiB postgresql-16-shacrypt_1.1-1PIGSTY~resolute_amd64.deb
postgresql-16-shacrypt 1.1 u26.aarch64 pigsty 31.4 KiB postgresql-16-shacrypt_1.1-1PIGSTY~resolute_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
postgresql-15-shacrypt 1.1 u26.x86_64 pigsty 32.2 KiB postgresql-15-shacrypt_1.1-1PIGSTY~resolute_amd64.deb
postgresql-15-shacrypt 1.1 u26.aarch64 pigsty 31.6 KiB postgresql-15-shacrypt_1.1-1PIGSTY~resolute_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
postgresql-14-shacrypt 1.1 u26.x86_64 pigsty 32.2 KiB postgresql-14-shacrypt_1.1-1PIGSTY~resolute_amd64.deb
postgresql-14-shacrypt 1.1 u26.aarch64 pigsty 31.6 KiB postgresql-14-shacrypt_1.1-1PIGSTY~resolute_arm64.deb

Source 

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'