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
13
 shacrypt -
RPM
PIGSTY
 1.1
18
17
16
15
14
13
 shacrypt_$v* -
DEB
PIGSTY
 1.1
18
17
16
15
14
13
 postgresql-$v-shacrypt -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
el9.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
el10.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
d12.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
d13.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
u22.x86_64
PIGSTY 1.1
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
PIGSTY 1.1
u24.x86_64
PIGSTY 1.1
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
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
Package Version OS ORG SIZE File URL
shacrypt_13 1.1 el8.x86_64 pigsty 19.8 KiB shacrypt_13-1.1-2PIGSTY.el8.x86_64.rpm
shacrypt_13 1.1 el8.aarch64 pigsty 19.4 KiB shacrypt_13-1.1-2PIGSTY.el8.aarch64.rpm
shacrypt_13 1.1 el9.x86_64 pigsty 19.2 KiB shacrypt_13-1.1-2PIGSTY.el9.x86_64.rpm
shacrypt_13 1.1 el9.aarch64 pigsty 19.1 KiB shacrypt_13-1.1-2PIGSTY.el9.aarch64.rpm
shacrypt_13 1.1 el10.x86_64 pigsty 18.9 KiB shacrypt_13-1.1-2PIGSTY.el10.x86_64.rpm
shacrypt_13 1.1 el10.aarch64 pigsty 18.9 KiB shacrypt_13-1.1-2PIGSTY.el10.aarch64.rpm
postgresql-13-shacrypt 1.1 d12.x86_64 pigsty 2.5 KiB postgresql-13-shacrypt_1.1-1PIGSTY~bookworm_amd64.deb
postgresql-13-shacrypt 1.1 d12.aarch64 pigsty 2.5 KiB postgresql-13-shacrypt_1.1-1PIGSTY~bookworm_arm64.deb
postgresql-13-shacrypt 1.1 d13.x86_64 pigsty 2.5 KiB postgresql-13-shacrypt_1.1-1PIGSTY~trixie_amd64.deb
postgresql-13-shacrypt 1.1 d13.aarch64 pigsty 2.5 KiB postgresql-13-shacrypt_1.1-1PIGSTY~trixie_arm64.deb
postgresql-13-shacrypt 1.1 u22.x86_64 pigsty 2.4 KiB postgresql-13-shacrypt_1.1-1PIGSTY~jammy_amd64.deb
postgresql-13-shacrypt 1.1 u22.aarch64 pigsty 2.4 KiB postgresql-13-shacrypt_1.1-1PIGSTY~jammy_arm64.deb
postgresql-13-shacrypt 1.1 u24.x86_64 pigsty 2.4 KiB postgresql-13-shacrypt_1.1-1PIGSTY~noble_amd64.deb
postgresql-13-shacrypt 1.1 u24.aarch64 pigsty 2.4 KiB postgresql-13-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 with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -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
pig install shacrypt -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION shacrypt;
Last updated on
xxhashcryptint