This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: SEC

SEC: Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Erros, Extension White List, …

1: passwordcheck_cracklib
2: supautils
3: pgsodium
4: supabase_vault
5: pg_session_jwt
6: anon
7: pg_tde
8: pgsmcrypto
9: pgaudit
10: pgauditlogtofile
11: pg_auth_mon
12: credcheck
13: pgcryptokey
14: pg_jobmon
15: logerrors
16: login_hook
17: set_user
18: pg_snakeoil
19: pgextwlist
20: pg_auditor
21: sslutils
22: noset
23: sepgsql
24: auth_delay
25: pgcrypto
26: passwordcheck

SEC category has 26 available extensions:

Name (Detail)	Package (Repo)	Repo	Version	Category	License	Description
passwordcheck_cracklib	`passwordcheck`	MIXED	3.1.0	`SEC`	LGPLv2	Strengthen PostgreSQL user password checks with cracklib
supautils	`supautils`	PIGSTY	2.6.0	`SEC`	Apache-2.0	Extension that secures a cluster on a cloud environment
pgsodium	`pgsodium`	PIGSTY	3.1.9	`SEC`	BSD 3	Postgres extension for libsodium functions
supabase_vault	`pg_vault`	PIGSTY	0.3.1	`SEC`	Apache-2.0	Supabase Vault Extension
pg_session_jwt	`pg_session_jwt`	PIGSTY	0.2.0	`SEC`	Apache-2.0	Manage authentication sessions using JWTs
anon	`pg_anon`	PIGSTY	2.0.0	`SEC`	PostgreSQL	PostgreSQL Anonymizer (anon) extension
pg_tde	`pg_tde`	PIGSTY	1.0	`SEC`	MIT	pg_tde access method
pgsmcrypto	`pgsmcrypto`	PIGSTY	0.1.0	`SEC`	MIT	PostgreSQL SM Algorithm Extension
pgaudit	`pgaudit`	PGDG	17.1	`SEC`	PostgreSQL	provides auditing functionality
pgauditlogtofile	`pgauditlogtofile`	PGDG	1.6.4	`SEC`	PostgreSQL	pgAudit addon to redirect audit log to an independent file
pg_auth_mon	`pg_auth_mon`	MIXED	3.0	`SEC`	MIT	monitor connection attempts per user
credcheck	`credcheck`	PGDG	3.0	`SEC`	MIT	credcheck - postgresql plain text credential checker
pgcryptokey	`pgcryptokey`	MIXED	0.85	`SEC`	PostgreSQL	cryptographic key management
pg_jobmon	`pg_jobmon`	MIXED	1.4.1	`SEC`	PostgreSQL	Extension for logging and monitoring functions in PostgreSQL
logerrors	`logerrors`	MIXED	2.1.3	`SEC`	BSD 3	Function for collecting statistics about messages in logfile
login_hook	`login_hook`	MIXED	1.6	`SEC`	GPLv3	login_hook - hook to execute login_hook.login() at login time
set_user	`set_user`	PGDG	4.1.0	`SEC`	PostgreSQL	similar to SET ROLE but with added logging
pg_snakeoil	`pg_snakeoil`	MIXED	1.4	`SEC`	PostgreSQL	The PostgreSQL Antivirus
pgextwlist	`pgextwlist`	PIGSTY	1.17	`SEC`	PostgreSQL	PostgreSQL Extension Whitelisting
pg_auditor	`pg_auditor`	PIGSTY	0.2	`SEC`	BSD 3	Audit data changes and provide flashback ability
sslutils	`sslutils`	PIGSTY	1.4	`SEC`	PostgreSQL	A Postgres extension for managing SSL certificates through SQL
noset	`pg_noset`	PIGSTY	0.3.0	`SEC`	AGPLv3	Module for blocking SET variables for non-super users.
sepgsql	`sepgsql`	CONTRIB	-	`SEC`	PostgreSQL	label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay	`auth_delay`	CONTRIB	-	`SEC`	PostgreSQL	pause briefly before reporting authentication failure
pgcrypto	`pgcrypto`	CONTRIB	1.3	`SEC`	PostgreSQL	cryptographic functions
passwordcheck	`passwordcheck`	CONTRIB	-	`SEC`	PostgreSQL	checks user passwords and reject weak password

1 - passwordcheck_cracklib

Strengthen PostgreSQL user password checks with cracklib

Overview

MIXED 3rd Party Extension: passwordcheck : Strengthen PostgreSQL user password checks with cracklib

Information

Extension ID: 7000
Extension Name: passwordcheck_cracklib
Package Name: passwordcheck
Category: SEC
License: LGPLv2
Website: https://github.com/devrimgunduz/passwordcheck_cracklib
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 3.1.0
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: passwordcheck_cracklib_$v*
RPM Ver : 3.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-passwordcheck-cracklib
DEB Ver : 3.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`passwordcheck_cracklib_17` PGDG 3.1.0	`passwordcheck_cracklib_16` PGDG 3.0.0	`passwordcheck_cracklib_15` PGDG 3.0.0	`passwordcheck_cracklib_14` PGDG 3.0.0	`passwordcheck_cracklib_13` PGDG 3.0.0
`el8`	`aarch64`	`passwordcheck_cracklib_17` PGDG 3.1.0	`passwordcheck_cracklib_16` PGDG 3.0.0	`passwordcheck_cracklib_15` PGDG 3.0.0	`passwordcheck_cracklib_14` PGDG 3.0.0	`passwordcheck_cracklib_13` PGDG 3.0.0
`el9`	`x86_64`	`passwordcheck_cracklib_17` PGDG 3.1.0	`passwordcheck_cracklib_16` PGDG 3.0.0	`passwordcheck_cracklib_15` PGDG 3.0.0	`passwordcheck_cracklib_14` PGDG 3.0.0	`passwordcheck_cracklib_13` PGDG 3.0.0
`el9`	`aarch64`	`passwordcheck_cracklib_17` PGDG 3.1.0	`passwordcheck_cracklib_16` PGDG 3.0.0	`passwordcheck_cracklib_15` PGDG 3.0.0	`passwordcheck_cracklib_14` PGDG 3.0.0	`passwordcheck_cracklib_13` PGDG 3.0.0
`d12`	`x86_64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0
`d12`	`aarch64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0
`u22`	`x86_64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0
`u22`	`aarch64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0
`u24`	`x86_64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0
`u24`	`aarch64`	`postgresql-17-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-16-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-15-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-14-passwordcheck-cracklib` PIGSTY 3.1.0	`postgresql-13-passwordcheck-cracklib` PIGSTY 3.1.0

Installation

Install passwordcheck_cracklib via the pig CLI tool:


pig ext install passwordcheck; 	# Extension Name
pig ext install passwordcheck_cracklib; 	# normalized package name

Install passwordcheck via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["passwordcheck"]}' # -l <cls>

Install passwordcheck RPM from YUM repo directly:

dnf install passwordcheck_cracklib_17*;
dnf install passwordcheck_cracklib_16*;
dnf install passwordcheck_cracklib_15*;
dnf install passwordcheck_cracklib_14*;
dnf install passwordcheck_cracklib_13*;

Install passwordcheck DEB from APT repo directly:

apt install postgresql-17-passwordcheck-cracklib;
apt install postgresql-16-passwordcheck-cracklib;
apt install postgresql-15-passwordcheck-cracklib;
apt install postgresql-14-passwordcheck-cracklib;
apt install postgresql-13-passwordcheck-cracklib;

Extension passwordcheck_cracklib has to be loaded via shared_preload_libraries

shared_preload_libraries = 'passwordcheck_cracklib'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

2 - supautils

Extension that secures a cluster on a cloud environment

Overview

PIGSTY 3rd Party Extension: supautils : Extension that secures a cluster on a cloud environment

Information

Extension ID: 7010
Extension Name: supautils
Package Name: supautils
Category: SEC
License: Apache-2.0
Website: https://github.com/supabase/supautils
Language: C
Extra Tags: supabase
Comment: N/A

Metadata

Latest Version: 2.9.2
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: supautils_$v
RPM Ver : 2.9.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-supautils
DEB Ver : 2.9.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`supautils_17` PIGSTY 2.9.2	`supautils_16` PIGSTY 2.9.2	`supautils_15` PIGSTY 2.9.2	`supautils_14` PIGSTY 2.9.2	`supautils_13` PIGSTY 2.9.2
`el8`	`aarch64`	`supautils_17` PIGSTY 2.9.2	`supautils_16` PIGSTY 2.9.2	`supautils_15` PIGSTY 2.9.2	`supautils_14` PIGSTY 2.9.2	`supautils_13` PIGSTY 2.9.2
`el9`	`x86_64`	`supautils_17` PIGSTY 2.9.2	`supautils_16` PIGSTY 2.9.2	`supautils_15` PIGSTY 2.9.2	`supautils_14` PIGSTY 2.9.2	`supautils_13` PIGSTY 2.9.2
`el9`	`aarch64`	`supautils_17` PIGSTY 2.9.2	`supautils_16` PIGSTY 2.9.2	`supautils_15` PIGSTY 2.9.2	`supautils_14` PIGSTY 2.9.2	`supautils_13` PIGSTY 2.9.2
`d12`	`x86_64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2
`d12`	`aarch64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2
`u22`	`x86_64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2
`u22`	`aarch64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2
`u24`	`x86_64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2
`u24`	`aarch64`	`postgresql-17-supautils` PIGSTY 2.9.2	`postgresql-16-supautils` PIGSTY 2.9.2	`postgresql-15-supautils` PIGSTY 2.9.2	`postgresql-14-supautils` PIGSTY 2.9.2	`postgresql-13-supautils` PIGSTY 2.9.2

Installation

Install supautils via the pig CLI tool:

pig ext install supautils

Install supautils via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["supautils"]}' # -l <cls>

Install supautils RPM from YUM repo directly:

dnf install supautils_17;
dnf install supautils_16;
dnf install supautils_15;
dnf install supautils_14;
dnf install supautils_13;

Install supautils DEB from APT repo directly:

apt install postgresql-17-supautils;
apt install postgresql-16-supautils;
apt install postgresql-15-supautils;
apt install postgresql-14-supautils;
apt install postgresql-13-supautils;

Extension supautils has to be loaded via shared_preload_libraries

shared_preload_libraries = 'supautils'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

3 - pgsodium

Postgres extension for libsodium functions

Overview

PIGSTY 3rd Party Extension: pgsodium : Postgres extension for libsodium functions

Information

Extension ID: 7020
Extension Name: pgsodium
Package Name: pgsodium
Category: SEC
License: BSD 3
Website: https://github.com/michelp/pgsodium
Language: C
Extra Tags: supabase
Comment:

Metadata

Latest Version: 3.1.9
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: pgsodium
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pgsodium_$v*
RPM Ver : 3.1.9
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgsodium
DEB Ver : 3.1.9
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgsodium_17` PGDG 3.1.9	`pgsodium_16` PGDG 3.1.9	`pgsodium_15` PGDG 3.1.9	`pgsodium_14` PGDG 3.1.9	`pgsodium_13` PGDG 3.1.9
`el8`	`aarch64`	`pgsodium_17` PGDG 3.1.9	`pgsodium_16` PGDG 3.1.9	`pgsodium_15` PGDG 3.1.9	`pgsodium_14` PGDG 3.1.9	`pgsodium_13` PGDG 3.1.9
`el9`	`x86_64`	`pgsodium_17` PGDG 3.1.9	`pgsodium_16` PGDG 3.1.9	`pgsodium_15` PGDG 3.1.9	`pgsodium_14` PGDG 3.1.9	`pgsodium_13` PGDG 3.1.9
`el9`	`aarch64`	`pgsodium_17` PGDG 3.1.9	`pgsodium_16` PGDG 3.1.9	`pgsodium_15` PGDG 3.1.9	`pgsodium_14` PGDG 3.1.9	`pgsodium_13` PGDG 3.1.9
`d12`	`x86_64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9
`d12`	`aarch64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9
`u22`	`x86_64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9
`u22`	`aarch64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9
`u24`	`x86_64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9
`u24`	`aarch64`	`postgresql-17-pgsodium` PIGSTY 3.1.9	`postgresql-16-pgsodium` PIGSTY 3.1.9	`postgresql-15-pgsodium` PIGSTY 3.1.9	`postgresql-14-pgsodium` PIGSTY 3.1.9	`postgresql-13-pgsodium` PIGSTY 3.1.9

Installation

Install pgsodium via the pig CLI tool:

pig ext install pgsodium

Install pgsodium via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgsodium"]}' # -l <cls>

Install pgsodium RPM from YUM repo directly:

dnf install pgsodium_17*;
dnf install pgsodium_16*;
dnf install pgsodium_15*;
dnf install pgsodium_14*;
dnf install pgsodium_13*;

Install pgsodium DEB from APT repo directly:

apt install postgresql-17-pgsodium;
apt install postgresql-16-pgsodium;
apt install postgresql-15-pgsodium;
apt install postgresql-14-pgsodium;
apt install postgresql-13-pgsodium;

Extension pgsodium has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pgsodium'; # add to pg cluster config

Create pgsodium extension on PostgreSQL cluster:

CREATE EXTENSION pgsodium;

4 - supabase_vault

Supabase Vault Extension

Overview

PIGSTY 3rd Party Extension: pg_vault : Supabase Vault Extension

Information

Extension ID: 7030
Extension Name: supabase_vault
Package Name: pg_vault
Category: SEC
License: Apache-2.0
Website: https://github.com/supabase/vault
Language: C
Extra Tags: supabase
Comment: N/A

Metadata

Latest Version: 0.3.1
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: vault
Requires: pgsodium

RPM / DEB

RPM Repo: PIGSTY
RPM Name: vault_$v*
RPM Ver : 0.3.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-vault
DEB Ver : 0.3.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`vault_17` PIGSTY 0.3.1	`vault_16` PIGSTY 0.3.1	`vault_15` PIGSTY 0.3.1	`vault_14` PIGSTY 0.3.1	`vault_13` PIGSTY 0.3.1
`el8`	`aarch64`	`vault_17` PIGSTY 0.3.1	`vault_16` PIGSTY 0.3.1	`vault_15` PIGSTY 0.3.1	`vault_14` PIGSTY 0.3.1	`vault_13` PIGSTY 0.3.1
`el9`	`x86_64`	`vault_17` PIGSTY 0.3.1	`vault_16` PIGSTY 0.3.1	`vault_15` PIGSTY 0.3.1	`vault_14` PIGSTY 0.3.1	`vault_13` PIGSTY 0.3.1
`el9`	`aarch64`	`vault_17` PIGSTY 0.3.1	`vault_16` PIGSTY 0.3.1	`vault_15` PIGSTY 0.3.1	`vault_14` PIGSTY 0.3.1	`vault_13` PIGSTY 0.3.1
`d12`	`x86_64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1
`d12`	`aarch64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1
`u22`	`x86_64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1
`u22`	`aarch64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1
`u24`	`x86_64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1
`u24`	`aarch64`	`postgresql-17-vault` PIGSTY 0.3.1	`postgresql-16-vault` PIGSTY 0.3.1	`postgresql-15-vault` PIGSTY 0.3.1	`postgresql-14-vault` PIGSTY 0.3.1	`postgresql-13-vault` PIGSTY 0.3.1

Installation

Install supabase_vault via the pig CLI tool:


pig ext install pg_vault; 	# Extension Name
pig ext install supabase_vault; 	# normalized package name

Install pg_vault via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_vault"]}' # -l <cls>

Install pg_vault RPM from YUM repo directly:

dnf install vault_17*;
dnf install vault_16*;
dnf install vault_15*;
dnf install vault_14*;
dnf install vault_13*;

Install pg_vault DEB from APT repo directly:

apt install postgresql-17-vault;
apt install postgresql-16-vault;
apt install postgresql-15-vault;
apt install postgresql-14-vault;
apt install postgresql-13-vault;

Create supabase_vault extension on PostgreSQL cluster:

CREATE EXTENSION supabase_vault CASCADE;

5 - pg_session_jwt

Manage authentication sessions using JWTs

Overview

PIGSTY 3rd Party Extension: pg_session_jwt : Manage authentication sessions using JWTs

Information

Extension ID: 7040
Extension Name: pg_session_jwt
Package Name: pg_session_jwt
Category: SEC
License: Apache-2.0
Website: https://github.com/neondatabase/pg_session_jwt
Language: Rust
Extra Tags: neon, pgrx
Comment:

Metadata

Latest Version: 0.3.1
Postgres Support: 17,16,15,14
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: auth
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_session_jwt_$v
RPM Ver : 0.3.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-session-jwt
DEB Ver : 0.3.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14
`el8`	`x86_64`	`pg_session_jwt_17` PIGSTY 0.3.1	`pg_session_jwt_16` PIGSTY 0.3.1	`pg_session_jwt_15` PIGSTY 0.3.1	`pg_session_jwt_14` PIGSTY 0.3.1
`el8`	`aarch64`	`pg_session_jwt_17` PIGSTY 0.3.1	`pg_session_jwt_16` PIGSTY 0.3.1	`pg_session_jwt_15` PIGSTY 0.3.1	`pg_session_jwt_14` PIGSTY 0.3.1
`el9`	`x86_64`	`pg_session_jwt_17` PIGSTY 0.3.1	`pg_session_jwt_16` PIGSTY 0.3.1	`pg_session_jwt_15` PIGSTY 0.3.1	`pg_session_jwt_14` PIGSTY 0.3.1
`el9`	`aarch64`	`pg_session_jwt_17` PIGSTY 0.3.1	`pg_session_jwt_16` PIGSTY 0.3.1	`pg_session_jwt_15` PIGSTY 0.3.1	`pg_session_jwt_14` PIGSTY 0.3.1
`d12`	`x86_64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1
`d12`	`aarch64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1
`u22`	`x86_64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1
`u22`	`aarch64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1
`u24`	`x86_64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1
`u24`	`aarch64`	`postgresql-17-pg-session-jwt` PIGSTY 0.3.1	`postgresql-16-pg-session-jwt` PIGSTY 0.3.1	`postgresql-15-pg-session-jwt` PIGSTY 0.3.1	`postgresql-14-pg-session-jwt` PIGSTY 0.3.1

Installation

Install pg_session_jwt via the pig CLI tool:

pig ext install pg_session_jwt

Install pg_session_jwt via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_session_jwt"]}' # -l <cls>

Install pg_session_jwt RPM from YUM repo directly:

dnf install pg_session_jwt_17;
dnf install pg_session_jwt_16;
dnf install pg_session_jwt_15;
dnf install pg_session_jwt_14;

Install pg_session_jwt DEB from APT repo directly:

apt install postgresql-17-pg-session-jwt;
apt install postgresql-16-pg-session-jwt;
apt install postgresql-15-pg-session-jwt;
apt install postgresql-14-pg-session-jwt;

Create pg_session_jwt extension on PostgreSQL cluster:

CREATE EXTENSION pg_session_jwt;

6 - anon

PostgreSQL Anonymizer (anon) extension

Overview

PIGSTY 3rd Party Extension: pg_anon : PostgreSQL Anonymizer (anon) extension

Information

Extension ID: 7050
Extension Name: anon
Package Name: pg_anon
Category: SEC
License: PostgreSQL
Website: https://gitlab.com/dalibo/postgresql_anonymizer/
Language: Rust
Extra Tags: pgrx
Comment:

Metadata

Latest Version: 2.1.1
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: anon
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_anon_$v
RPM Ver : 2.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-anon
DEB Ver : 2.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_anon_17` PIGSTY 2.1.1	`pg_anon_16` PIGSTY 2.1.1	`pg_anon_15` PIGSTY 2.1.1	`pg_anon_14` PIGSTY 2.1.1	`pg_anon_13` PIGSTY 2.1.1
`el8`	`aarch64`	`pg_anon_17` PIGSTY 2.1.1	`pg_anon_16` PIGSTY 2.1.1	`pg_anon_15` PIGSTY 2.1.1	`pg_anon_14` PIGSTY 2.1.1	`pg_anon_13` PIGSTY 2.1.1
`el9`	`x86_64`	`pg_anon_17` PIGSTY 2.1.1	`pg_anon_16` PIGSTY 2.1.1	`pg_anon_15` PIGSTY 2.1.1	`pg_anon_14` PIGSTY 2.1.1	`pg_anon_13` PIGSTY 2.1.1
`el9`	`aarch64`	`pg_anon_17` PIGSTY 2.1.1	`pg_anon_16` PIGSTY 2.1.1	`pg_anon_15` PIGSTY 2.1.1	`pg_anon_14` PIGSTY 2.1.1	`pg_anon_13` PIGSTY 2.1.1
`d12`	`x86_64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1
`d12`	`aarch64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1
`u22`	`x86_64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1
`u22`	`aarch64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1
`u24`	`x86_64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1
`u24`	`aarch64`	`postgresql-17-pg-anon` PIGSTY 2.1.1	`postgresql-16-pg-anon` PIGSTY 2.1.1	`postgresql-15-pg-anon` PIGSTY 2.1.1	`postgresql-14-pg-anon` PIGSTY 2.1.1	`postgresql-13-pg-anon` PIGSTY 2.1.1

Installation

Install anon via the pig CLI tool:


pig ext install pg_anon; 	# Extension Name
pig ext install anon; 	# normalized package name

Install pg_anon via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_anon"]}' # -l <cls>

Install pg_anon RPM from YUM repo directly:

dnf install pg_anon_17;
dnf install pg_anon_16;
dnf install pg_anon_15;
dnf install pg_anon_14;
dnf install pg_anon_13;

Install pg_anon DEB from APT repo directly:

apt install postgresql-17-pg-anon;
apt install postgresql-16-pg-anon;
apt install postgresql-15-pg-anon;
apt install postgresql-14-pg-anon;
apt install postgresql-13-pg-anon;

Extension anon has to be loaded via shared_preload_libraries

shared_preload_libraries = 'anon'; # add to pg cluster config

Create anon extension on PostgreSQL cluster:

CREATE EXTENSION anon;

7 - pg_tde

pg_tde access method

Overview

PIGSTY 3rd Party Extension: pg_tde : pg_tde access method

Information

Extension ID: 7060
Extension Name: pg_tde
Package Name: pg_tde
Category: SEC
License: MIT
Website: https://github.com/Percona-Lab/pg_tde
Language: C
Extra Tags: beta
Comment: N/A

Metadata

Latest Version: 1.0
Postgres Support: 16
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_tde_$v*
RPM Ver : 1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-tde
DEB Ver : 1.0
DEB Deps: N/A

Availability

OS	Arch	PG16
`el8`	`x86_64`	`pg_tde_16` PIGSTY 1.0.0
`el8`	`aarch64`	`pg_tde_16` PIGSTY 1.0.0
`el9`	`x86_64`	`pg_tde_16` PIGSTY 1.0.0
`el9`	`aarch64`	`pg_tde_16` PIGSTY 1.0.0
`d12`	`x86_64`	`postgresql-16-pg-tde` PIGSTY 1.0.0
`d12`	`aarch64`	`postgresql-16-pg-tde` PIGSTY 1.0.0
`u22`	`x86_64`	`postgresql-16-pg-tde` PIGSTY 1.0.0
`u22`	`aarch64`	`postgresql-16-pg-tde` PIGSTY 1.0.0
`u24`	`x86_64`	`postgresql-16-pg-tde` PIGSTY 1.0.0
`u24`	`aarch64`	`postgresql-16-pg-tde` PIGSTY 1.0.0

Installation

Install pg_tde via the pig CLI tool:

pig ext install pg_tde

Install pg_tde via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_tde"]}' # -l <cls>

Install pg_tde RPM from YUM repo directly:

dnf install pg_tde_16*;

Install pg_tde DEB from APT repo directly:

apt install postgresql-16-pg-tde;

Extension pg_tde has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pg_tde'; # add to pg cluster config

Create pg_tde extension on PostgreSQL cluster:

CREATE EXTENSION pg_tde;

8 - pgsmcrypto

PostgreSQL SM Algorithm Extension

Overview

PIGSTY 3rd Party Extension: pgsmcrypto : PostgreSQL SM Algorithm Extension

Information

Extension ID: 7070
Extension Name: pgsmcrypto
Package Name: pgsmcrypto
Category: SEC
License: MIT
Website: https://github.com/zhuobie/pgsmcrypto
Language: Rust
Extra Tags: pgrx
Comment:

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pgsmcrypto_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgsmcrypto
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgsmcrypto_17` PIGSTY 0.1.0	`pgsmcrypto_16` PIGSTY 0.1.0	`pgsmcrypto_15` PIGSTY 0.1.0	`pgsmcrypto_14` PIGSTY 0.1.0	`pgsmcrypto_13` PIGSTY 0.1.0
`el8`	`aarch64`	`pgsmcrypto_17` PIGSTY 0.1.0	`pgsmcrypto_16` PIGSTY 0.1.0	`pgsmcrypto_15` PIGSTY 0.1.0	`pgsmcrypto_14` PIGSTY 0.1.0	`pgsmcrypto_13` PIGSTY 0.1.0
`el9`	`x86_64`	`pgsmcrypto_17` PIGSTY 0.1.0	`pgsmcrypto_16` PIGSTY 0.1.0	`pgsmcrypto_15` PIGSTY 0.1.0	`pgsmcrypto_14` PIGSTY 0.1.0	`pgsmcrypto_13` PIGSTY 0.1.0
`el9`	`aarch64`	`pgsmcrypto_17` PIGSTY 0.1.0	`pgsmcrypto_16` PIGSTY 0.1.0	`pgsmcrypto_15` PIGSTY 0.1.0	`pgsmcrypto_14` PIGSTY 0.1.0	`pgsmcrypto_13` PIGSTY 0.1.0
`d12`	`x86_64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0
`d12`	`aarch64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0
`u22`	`x86_64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0
`u22`	`aarch64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0
`u24`	`x86_64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0
`u24`	`aarch64`	`postgresql-17-pgsmcrypto` PIGSTY 0.1.0	`postgresql-16-pgsmcrypto` PIGSTY 0.1.0	`postgresql-15-pgsmcrypto` PIGSTY 0.1.0	`postgresql-14-pgsmcrypto` PIGSTY 0.1.0	`postgresql-13-pgsmcrypto` PIGSTY 0.1.0

Installation

Install pgsmcrypto via the pig CLI tool:

pig ext install pgsmcrypto

Install pgsmcrypto via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgsmcrypto"]}' # -l <cls>

Install pgsmcrypto RPM from YUM repo directly:

dnf install pgsmcrypto_17;
dnf install pgsmcrypto_16;
dnf install pgsmcrypto_15;
dnf install pgsmcrypto_14;
dnf install pgsmcrypto_13;

Install pgsmcrypto DEB from APT repo directly:

apt install postgresql-17-pgsmcrypto;
apt install postgresql-16-pgsmcrypto;
apt install postgresql-15-pgsmcrypto;
apt install postgresql-14-pgsmcrypto;
apt install postgresql-13-pgsmcrypto;

Create pgsmcrypto extension on PostgreSQL cluster:

CREATE EXTENSION pgsmcrypto;

9 - pgaudit

provides auditing functionality

Overview

PGDG 1st Party Extension: pgaudit : provides auditing functionality

Information

Extension ID: 7080
Extension Name: pgaudit
Package Name: pgaudit
Category: SEC
License: PostgreSQL
Website: https://github.com/pgaudit/pgaudit
Language: C
Extra Tags: N/A
Comment:

Metadata

Latest Version: 17.1
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pgaudit_$v*
RPM Ver : 17.0
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-pgaudit
DEB Ver : 17.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgaudit_17` PGDG 17.1	`pgaudit_16` PGDG 16.1	`pgaudit17_15` PGDG 1.7.1	`pgaudit16_14` PGDG 1.6.3	`pgaudit15_13` PGDG 1.5.3
`el8`	`aarch64`	`pgaudit_17` PGDG 17.1	`pgaudit_16` PGDG 16.1	`pgaudit17_15` PGDG 1.7.1	`pgaudit16_14` PGDG 1.6.3	`pgaudit15_13` PGDG 1.5.3
`el9`	`x86_64`	`pgaudit_17` PGDG 17.1	`pgaudit_16` PGDG 16.1	`pgaudit17_15` PGDG 1.7.1	`pgaudit16_14` PGDG 1.6.3	`pgaudit15_13` PGDG 1.5.3
`el9`	`aarch64`	`pgaudit_17` PGDG 17.1	`pgaudit_16` PGDG 16.1	`pgaudit17_15` PGDG 1.7.1	`pgaudit16_14` PGDG 1.6.3	`pgaudit15_13` PGDG 1.5.3
`d12`	`x86_64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3
`d12`	`aarch64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3
`u22`	`x86_64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3
`u22`	`aarch64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3
`u24`	`x86_64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3
`u24`	`aarch64`	`postgresql-17-pgaudit` PGDG 17.1	`postgresql-16-pgaudit` PGDG 16.1	`postgresql-15-pgaudit` PGDG 1.7.1	`postgresql-14-pgaudit` PGDG 1.6.3	`postgresql-13-pgaudit` PGDG 1.5.3

Installation

Install pgaudit via the pig CLI tool:

pig ext install pgaudit

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgaudit"]}'   # common case
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgaudit17"]}' # pg15 @ el
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgaudit16"]}' # pg14 @ el
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgaudit15"]}' # pg13 @ el

Install pgaudit RPM from YUM repo directly:

dnf install pgaudit_17*;
dnf install pgaudit_16*;
dnf install pgaudit_15*;
dnf install pgaudit_14*;
dnf install pgaudit_13*;

Install pgaudit DEB from APT repo directly:

apt install postgresql-17-pgaudit;
apt install postgresql-16-pgaudit;
apt install postgresql-15-pgaudit;
apt install postgresql-14-pgaudit;
apt install postgresql-13-pgaudit;

Extension pgaudit has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pgaudit'; # add to pg cluster config

Create pgaudit extension on PostgreSQL cluster:

CREATE EXTENSION pgaudit;

10 - pgauditlogtofile

pgAudit addon to redirect audit log to an independent file

Overview

PGDG 1st Party Extension: pgauditlogtofile : pgAudit addon to redirect audit log to an independent file

Information

Extension ID: 7090
Extension Name: pgauditlogtofile
Package Name: pgauditlogtofile
Category: SEC
License: PostgreSQL
Website: https://github.com/fmbiete/pgauditlogtofile
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.6.4
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pgauditlogtofile_$v*
RPM Ver : 1.6.4
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-pgauditlogtofile
DEB Ver : 1.6.4
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgauditlogtofile_17` PGDG 1.6.4	`pgauditlogtofile_16` PGDG 1.6.4	`pgauditlogtofile_15` PGDG 1.6.4	`pgauditlogtofile_14` PGDG 1.6.4	`pgauditlogtofile_13` PGDG 1.6.4
`el8`	`aarch64`	`pgauditlogtofile_17` PGDG 1.6.4	`pgauditlogtofile_16` PGDG 1.6.4	`pgauditlogtofile_15` PGDG 1.6.4	`pgauditlogtofile_14` PGDG 1.6.4	`pgauditlogtofile_13` PGDG 1.6.4
`el9`	`x86_64`	`pgauditlogtofile_17` PGDG 1.6.4	`pgauditlogtofile_16` PGDG 1.6.4	`pgauditlogtofile_15` PGDG 1.6.4	`pgauditlogtofile_14` PGDG 1.6.4	`pgauditlogtofile_13` PGDG 1.6.4
`el9`	`aarch64`	`pgauditlogtofile_17` PGDG 1.6.4	`pgauditlogtofile_16` PGDG 1.6.4	`pgauditlogtofile_15` PGDG 1.6.4	`pgauditlogtofile_14` PGDG 1.6.4	`pgauditlogtofile_13` PGDG 1.6.4
`d12`	`x86_64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4
`d12`	`aarch64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4
`u22`	`x86_64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4
`u22`	`aarch64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4
`u24`	`x86_64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4
`u24`	`aarch64`	`postgresql-17-pgauditlogtofile` PGDG 1.6.4	`postgresql-16-pgauditlogtofile` PGDG 1.6.4	`postgresql-15-pgauditlogtofile` PGDG 1.6.4	`postgresql-14-pgauditlogtofile` PGDG 1.6.4	`postgresql-13-pgauditlogtofile` PGDG 1.6.4

Installation

Install pgauditlogtofile via the pig CLI tool:

pig ext install pgauditlogtofile

Install pgauditlogtofile via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgauditlogtofile"]}' # -l <cls>

Install pgauditlogtofile RPM from YUM repo directly:

dnf install pgauditlogtofile_17*;
dnf install pgauditlogtofile_16*;
dnf install pgauditlogtofile_15*;
dnf install pgauditlogtofile_14*;
dnf install pgauditlogtofile_13*;

Install pgauditlogtofile DEB from APT repo directly:

apt install postgresql-17-pgauditlogtofile;
apt install postgresql-16-pgauditlogtofile;
apt install postgresql-15-pgauditlogtofile;
apt install postgresql-14-pgauditlogtofile;
apt install postgresql-13-pgauditlogtofile;

Create pgauditlogtofile extension on PostgreSQL cluster:

CREATE EXTENSION pgauditlogtofile;

11 - pg_auth_mon

monitor connection attempts per user

Overview

MIXED 3rd Party Extension: pg_auth_mon : monitor connection attempts per user

Information

Extension ID: 7100
Extension Name: pg_auth_mon
Package Name: pg_auth_mon
Category: SEC
License: MIT
Website: https://github.com/RafiaSabih/pg_auth_mon
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 3.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pg_auth_mon_$v*
RPM Ver : 3.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-auth-mon
DEB Ver : 3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_auth_mon_17` PGDG 3.0	`pg_auth_mon_16` PGDG 2.0	`pg_auth_mon_15` PGDG 2.0	`pg_auth_mon_14` PGDG 2.0	`pg_auth_mon_13` PGDG 2.0
`el8`	`aarch64`	`pg_auth_mon_17` PGDG 3.0	`pg_auth_mon_16` PGDG 2.0	`pg_auth_mon_15` PGDG 2.0	`pg_auth_mon_14` PGDG 2.0	`pg_auth_mon_13` PGDG 2.0
`el9`	`x86_64`	`pg_auth_mon_17` PGDG 3.0	`pg_auth_mon_16` PGDG 2.0	`pg_auth_mon_15` PGDG 2.0	`pg_auth_mon_14` PGDG 2.0	`pg_auth_mon_13` PGDG 2.0
`el9`	`aarch64`	`pg_auth_mon_17` PGDG 3.0	`pg_auth_mon_16` PGDG 2.0	`pg_auth_mon_15` PGDG 2.0	`pg_auth_mon_14` PGDG 2.0	`pg_auth_mon_13` PGDG 2.0
`d12`	`x86_64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0
`d12`	`aarch64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0
`u22`	`x86_64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0
`u22`	`aarch64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0
`u24`	`x86_64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0
`u24`	`aarch64`	`postgresql-17-pg-auth-mon` PIGSTY 3.0	`postgresql-16-pg-auth-mon` PIGSTY 3.0	`postgresql-15-pg-auth-mon` PIGSTY 3.0	`postgresql-14-pg-auth-mon` PIGSTY 3.0	`postgresql-13-pg-auth-mon` PIGSTY 3.0

Installation

Install pg_auth_mon via the pig CLI tool:

pig ext install pg_auth_mon

Install pg_auth_mon via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_auth_mon"]}' # -l <cls>

Install pg_auth_mon RPM from YUM repo directly:

dnf install pg_auth_mon_17*;
dnf install pg_auth_mon_16*;
dnf install pg_auth_mon_15*;
dnf install pg_auth_mon_14*;
dnf install pg_auth_mon_13*;

Install pg_auth_mon DEB from APT repo directly:

apt install postgresql-17-pg-auth-mon;
apt install postgresql-16-pg-auth-mon;
apt install postgresql-15-pg-auth-mon;
apt install postgresql-14-pg-auth-mon;
apt install postgresql-13-pg-auth-mon;

Create pg_auth_mon extension on PostgreSQL cluster:

CREATE EXTENSION pg_auth_mon;

12 - credcheck

credcheck - postgresql plain text credential checker

Overview

PGDG 1st Party Extension: credcheck : credcheck - postgresql plain text credential checker

Information

Extension ID: 7110
Extension Name: credcheck
Package Name: credcheck
Category: SEC
License: MIT
Website: https://github.com/MigOpsRepos/credcheck
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 3.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: credcheck_$v*
RPM Ver : 3.0
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-credcheck
DEB Ver : 3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`credcheck_17` PGDG 3.0	`credcheck_16` PGDG 3.0	`credcheck_15` PGDG 3.0	`credcheck_14` PGDG 3.0	`credcheck_13` PGDG 3.0
`el8`	`aarch64`	`credcheck_17` PGDG 3.0	`credcheck_16` PGDG 3.0	`credcheck_15` PGDG 3.0	`credcheck_14` PGDG 3.0	`credcheck_13` PGDG 3.0
`el9`	`x86_64`	`credcheck_17` PGDG 3.0	`credcheck_16` PGDG 3.0	`credcheck_15` PGDG 3.0	`credcheck_14` PGDG 3.0	`credcheck_13` PGDG 3.0
`el9`	`aarch64`	`credcheck_17` PGDG 3.0	`credcheck_16` PGDG 3.0	`credcheck_15` PGDG 3.0	`credcheck_14` PGDG 3.0	`credcheck_13` PGDG 3.0
`d12`	`x86_64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0
`d12`	`aarch64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0
`u22`	`x86_64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0
`u22`	`aarch64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0
`u24`	`x86_64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0
`u24`	`aarch64`	`postgresql-17-credcheck` PGDG 3.0	`postgresql-16-credcheck` PGDG 3.0	`postgresql-15-credcheck` PGDG 3.0	`postgresql-14-credcheck` PGDG 3.0	`postgresql-13-credcheck` PGDG 3.0

Installation

Install credcheck via the pig CLI tool:

pig ext install credcheck

Install credcheck via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["credcheck"]}' # -l <cls>

Install credcheck RPM from YUM repo directly:

dnf install credcheck_17*;
dnf install credcheck_16*;
dnf install credcheck_15*;
dnf install credcheck_14*;
dnf install credcheck_13*;

Install credcheck DEB from APT repo directly:

apt install postgresql-17-credcheck;
apt install postgresql-16-credcheck;
apt install postgresql-15-credcheck;
apt install postgresql-14-credcheck;
apt install postgresql-13-credcheck;

Create credcheck extension on PostgreSQL cluster:

CREATE EXTENSION credcheck;

13 - pgcryptokey

cryptographic key management

Overview

MIXED 3rd Party Extension: pgcryptokey : cryptographic key management

Information

Extension ID: 7120
Extension Name: pgcryptokey
Package Name: pgcryptokey
Category: SEC
License: PostgreSQL
Website: https://momjian.us/download/pgcryptokey/
Language: C
Extra Tags: pgdg-flaw
Comment:

Metadata

Latest Version: 0.85
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: pgcrypto

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pgcryptokey_$v
RPM Ver : 0.85
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgcryptokey
DEB Ver : 0.85
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgcryptokey_17` PGDG 0.85	`pgcryptokey_16` PGDG 0.85	`pgcryptokey_15` PGDG 0.85	`pgcryptokey_14` PGDG 0.85	`pgcryptokey_13` PIGSTY 0.85
`el8`	`aarch64`	`pgcryptokey_17` PGDG 0.85	`pgcryptokey_16` PGDG 0.85	`pgcryptokey_15` PGDG 0.85	`pgcryptokey_14` PGDG 0.85	`pgcryptokey_13` PGDG 0.85
`el9`	`x86_64`	`pgcryptokey_17` PGDG 0.85	`pgcryptokey_16` PGDG 0.85	`pgcryptokey_15` PGDG 0.85	`pgcryptokey_14` PIGSTY 0.85	`pgcryptokey_13` PIGSTY 0.85
`el9`	`aarch64`	`pgcryptokey_17` PGDG 0.85	`pgcryptokey_16` PGDG 0.85	`pgcryptokey_15` PGDG 0.85	`pgcryptokey_14` PGDG 0.85	`pgcryptokey_13` PGDG 0.85
`d12`	`x86_64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85
`d12`	`aarch64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85
`u22`	`x86_64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85
`u22`	`aarch64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85
`u24`	`x86_64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85
`u24`	`aarch64`	`postgresql-17-pgcryptokey` PIGSTY 0.85	`postgresql-16-pgcryptokey` PIGSTY 0.85	`postgresql-15-pgcryptokey` PIGSTY 0.85	`postgresql-14-pgcryptokey` PIGSTY 0.85	`postgresql-13-pgcryptokey` PIGSTY 0.85

Installation

Install pgcryptokey via the pig CLI tool:

pig ext install pgcryptokey

Install pgcryptokey via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgcryptokey"]}' # -l <cls>

Install pgcryptokey RPM from YUM repo directly:

dnf install pgcryptokey_17;
dnf install pgcryptokey_16;
dnf install pgcryptokey_15;
dnf install pgcryptokey_14;
dnf install pgcryptokey_13;

Install pgcryptokey DEB from APT repo directly:

apt install postgresql-17-pgcryptokey;
apt install postgresql-16-pgcryptokey;
apt install postgresql-15-pgcryptokey;
apt install postgresql-14-pgcryptokey;
apt install postgresql-13-pgcryptokey;

Create pgcryptokey extension on PostgreSQL cluster:

CREATE EXTENSION pgcryptokey CASCADE;

14 - pg_jobmon

Extension for logging and monitoring functions in PostgreSQL

Overview

MIXED 3rd Party Extension: pg_jobmon : Extension for logging and monitoring functions in PostgreSQL

Information

Extension ID: 7130
Extension Name: pg_jobmon
Package Name: pg_jobmon
Category: SEC
License: PostgreSQL
Website: https://github.com/omniti-labs/pg_jobmon
Language: SQL
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.4.1
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: dblink

RPM / DEB

RPM Repo: PGDG
RPM Name: pg_jobmon_$v
RPM Ver : 1.4.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-jobmon
DEB Ver : 1.4.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_jobmon_17` PGDG 1.4.1	`pg_jobmon_16` PGDG 1.4.1	`pg_jobmon_15` PGDG 1.4.1	`pg_jobmon_14` PGDG 1.4.1	`pg_jobmon_13` PGDG 1.4.1
`el8`	`aarch64`	`pg_jobmon_17` PGDG 1.4.1	`pg_jobmon_16` PGDG 1.4.1	`pg_jobmon_15` PGDG 1.4.1	`pg_jobmon_14` PGDG 1.4.1	`pg_jobmon_13` PGDG 1.4.1
`el9`	`x86_64`	`pg_jobmon_17` PGDG 1.4.1	`pg_jobmon_16` PGDG 1.4.1	`pg_jobmon_15` PGDG 1.4.1	`pg_jobmon_14` PGDG 1.4.1	`pg_jobmon_13` PGDG 1.4.1
`el9`	`aarch64`	`pg_jobmon_17` PGDG 1.4.1	`pg_jobmon_16` PGDG 1.4.1	`pg_jobmon_15` PGDG 1.4.1	`pg_jobmon_14` PGDG 1.4.1	`pg_jobmon_13` PGDG 1.4.1
`d12`	`x86_64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1
`d12`	`aarch64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1
`u22`	`x86_64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1
`u22`	`aarch64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1
`u24`	`x86_64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1
`u24`	`aarch64`	`postgresql-17-pg-jobmon` PIGSTY 1.4.1	`postgresql-16-pg-jobmon` PIGSTY 1.4.1	`postgresql-15-pg-jobmon` PIGSTY 1.4.1	`postgresql-14-pg-jobmon` PIGSTY 1.4.1	`postgresql-13-pg-jobmon` PIGSTY 1.4.1

Installation

Install pg_jobmon via the pig CLI tool:

pig ext install pg_jobmon

Install pg_jobmon via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_jobmon"]}' # -l <cls>

Install pg_jobmon RPM from YUM repo directly:

dnf install pg_jobmon_17;
dnf install pg_jobmon_16;
dnf install pg_jobmon_15;
dnf install pg_jobmon_14;
dnf install pg_jobmon_13;

Install pg_jobmon DEB from APT repo directly:

apt install postgresql-17-pg-jobmon;
apt install postgresql-16-pg-jobmon;
apt install postgresql-15-pg-jobmon;
apt install postgresql-14-pg-jobmon;
apt install postgresql-13-pg-jobmon;

Create pg_jobmon extension on PostgreSQL cluster:

CREATE EXTENSION pg_jobmon CASCADE;

15 - logerrors

Function for collecting statistics about messages in logfile

Overview

MIXED 3rd Party Extension: logerrors : Function for collecting statistics about messages in logfile

Information

Extension ID: 7140
Extension Name: logerrors
Package Name: logerrors
Category: SEC
License: BSD 3
Website: https://github.com/munakoiso/logerrors
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 2.1.3
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: logerrors_$v*
RPM Ver : 2.1.3
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-logerrors
DEB Ver : 2.1.3
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`logerrors_17` PGDG 2.1.3	`logerrors_16` PGDG 2.1.3	`logerrors_15` PGDG 2.1.3	`logerrors_14` PGDG 2.1.3	`logerrors_13` PGDG 2.1.3
`el8`	`aarch64`	`logerrors_17` PGDG 2.1.3	`logerrors_16` PGDG 2.1.3	`logerrors_15` PGDG 2.1.3	`logerrors_14` PGDG 2.1.3	`logerrors_13` PGDG 2.1.3
`el9`	`x86_64`	`logerrors_17` PGDG 2.1.3	`logerrors_16` PGDG 2.1.3	`logerrors_15` PGDG 2.1.3	`logerrors_14` PGDG 2.1.3	`logerrors_13` PGDG 2.1.3
`el9`	`aarch64`	`logerrors_17` PGDG 2.1.3	`logerrors_16` PGDG 2.1.3	`logerrors_15` PGDG 2.1.3	`logerrors_14` PGDG 2.1.3	`logerrors_13` PGDG 2.1.3
`d12`	`x86_64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3
`d12`	`aarch64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3
`u22`	`x86_64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3
`u22`	`aarch64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3
`u24`	`x86_64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3
`u24`	`aarch64`	`postgresql-17-logerrors` PIGSTY 2.1.3	`postgresql-16-logerrors` PIGSTY 2.1.3	`postgresql-15-logerrors` PIGSTY 2.1.3	`postgresql-14-logerrors` PIGSTY 2.1.3	`postgresql-13-logerrors` PIGSTY 2.1.3

Installation

Install logerrors via the pig CLI tool:

pig ext install logerrors

Install logerrors via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["logerrors"]}' # -l <cls>

Install logerrors RPM from YUM repo directly:

dnf install logerrors_17*;
dnf install logerrors_16*;
dnf install logerrors_15*;
dnf install logerrors_14*;
dnf install logerrors_13*;

Install logerrors DEB from APT repo directly:

apt install postgresql-17-logerrors;
apt install postgresql-16-logerrors;
apt install postgresql-15-logerrors;
apt install postgresql-14-logerrors;
apt install postgresql-13-logerrors;

Create logerrors extension on PostgreSQL cluster:

CREATE EXTENSION logerrors;

16 - login_hook

login_hook - hook to execute login_hook.login() at login time

Overview

MIXED 3rd Party Extension: login_hook : login_hook - hook to execute login_hook.login() at login time

Information

Extension ID: 7150
Extension Name: login_hook
Package Name: login_hook
Category: SEC
License: GPLv3
Website: https://github.com/splendiddata/login_hook
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.6
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: login_hook
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: login_hook_$v*
RPM Ver : 1.6
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-login-hook
DEB Ver : 1.6
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`login_hook_17` PGDG 1.7	`login_hook_16` PGDG 1.7	`login_hook_15` PGDG 1.7	`login_hook_14` PGDG 1.7	`login_hook_13` PGDG 1.7
`el8`	`aarch64`	`login_hook_17` PGDG 1.7	`login_hook_16` PGDG 1.7	`login_hook_15` PGDG 1.7	`login_hook_14` PGDG 1.7	`login_hook_13` PGDG 1.7
`el9`	`x86_64`	`login_hook_17` PGDG 1.7	`login_hook_16` PGDG 1.7	`login_hook_15` PGDG 1.7	`login_hook_14` PGDG 1.7	`login_hook_13` PGDG 1.7
`el9`	`aarch64`	`login_hook_17` PGDG 1.7	`login_hook_16` PGDG 1.7	`login_hook_15` PGDG 1.7	`login_hook_14` PGDG 1.7	`login_hook_13` PGDG 1.7
`d12`	`x86_64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6
`d12`	`aarch64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6
`u22`	`x86_64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6
`u22`	`aarch64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6
`u24`	`x86_64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6
`u24`	`aarch64`	`postgresql-17-login-hook` PIGSTY 1.6	`postgresql-16-login-hook` PIGSTY 1.6	`postgresql-15-login-hook` PIGSTY 1.6	`postgresql-14-login-hook` PIGSTY 1.6	`postgresql-13-login-hook` PIGSTY 1.6

Installation

Install login_hook via the pig CLI tool:

pig ext install login_hook

Install login_hook via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["login_hook"]}' # -l <cls>

Install login_hook RPM from YUM repo directly:

dnf install login_hook_17*;
dnf install login_hook_16*;
dnf install login_hook_15*;
dnf install login_hook_14*;
dnf install login_hook_13*;

Install login_hook DEB from APT repo directly:

apt install postgresql-17-login-hook;
apt install postgresql-16-login-hook;
apt install postgresql-15-login-hook;
apt install postgresql-14-login-hook;
apt install postgresql-13-login-hook;

Create login_hook extension on PostgreSQL cluster:

CREATE EXTENSION login_hook;

17 - set_user

similar to SET ROLE but with added logging

Overview

PGDG 1st Party Extension: set_user : similar to SET ROLE but with added logging

Information

Extension ID: 7160
Extension Name: set_user
Package Name: set_user
Category: SEC
License: PostgreSQL
Website: https://github.com/pgaudit/set_user
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 4.1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: set_user_$v*
RPM Ver : 4.1.0
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-set-user
DEB Ver : 4.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`set_user_17` PGDG 4.1.0	`set_user_16` PGDG 4.1.0	`set_user_15` PGDG 4.1.0	`set_user_14` PGDG 4.1.0	`set_user_13` PGDG 4.1.0
`el8`	`aarch64`	`set_user_17` PGDG 4.1.0	`set_user_16` PGDG 4.1.0	`set_user_15` PGDG 4.1.0	`set_user_14` PGDG 4.1.0	`set_user_13` PGDG 4.1.0
`el9`	`x86_64`	`set_user_17` PGDG 4.1.0	`set_user_16` PGDG 4.1.0	`set_user_15` PGDG 4.1.0	`set_user_14` PGDG 4.1.0	`set_user_13` PGDG 4.1.0
`el9`	`aarch64`	`set_user_17` PGDG 4.1.0	`set_user_16` PGDG 4.1.0	`set_user_15` PGDG 4.1.0	`set_user_14` PGDG 4.1.0	`set_user_13` PGDG 4.1.0
`d12`	`x86_64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0
`d12`	`aarch64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0
`u22`	`x86_64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0
`u22`	`aarch64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0
`u24`	`x86_64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0
`u24`	`aarch64`	`postgresql-17-set-user` PGDG 4.1.0	`postgresql-16-set-user` PGDG 4.1.0	`postgresql-15-set-user` PGDG 4.1.0	`postgresql-14-set-user` PGDG 4.1.0	`postgresql-13-set-user` PGDG 4.1.0

Installation

Install set_user via the pig CLI tool:

pig ext install set_user

Install set_user via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["set_user"]}' # -l <cls>

Install set_user RPM from YUM repo directly:

dnf install set_user_17*;
dnf install set_user_16*;
dnf install set_user_15*;
dnf install set_user_14*;
dnf install set_user_13*;

Install set_user DEB from APT repo directly:

apt install postgresql-17-set-user;
apt install postgresql-16-set-user;
apt install postgresql-15-set-user;
apt install postgresql-14-set-user;
apt install postgresql-13-set-user;

Create set_user extension on PostgreSQL cluster:

CREATE EXTENSION set_user;

18 - pg_snakeoil

The PostgreSQL Antivirus

Overview

MIXED 3rd Party Extension: pg_snakeoil : The PostgreSQL Antivirus

Information

Extension ID: 7170
Extension Name: pg_snakeoil
Package Name: pg_snakeoil
Category: SEC
License: PostgreSQL
Website: https://github.com/credativ/pg_snakeoil
Language: C
Extra Tags: N/A
Comment:

Metadata

Latest Version: 1.4
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_snakeoil_$v*
RPM Ver : 1.4
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-snakeoil
DEB Ver : 1.4
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_snakeoil_17` PIGSTY 1.4	`pg_snakeoil_16` PIGSTY 1.4	`pg_snakeoil_15` PIGSTY 1.4	`pg_snakeoil_14` PIGSTY 1.4	`pg_snakeoil_13` PIGSTY 1.4
`el8`	`aarch64`	`pg_snakeoil_17` PIGSTY 1.4	`pg_snakeoil_16` PIGSTY 1.4	`pg_snakeoil_15` PIGSTY 1.4	`pg_snakeoil_14` PIGSTY 1.4	`pg_snakeoil_13` PIGSTY 1.4
`el9`	`x86_64`	`pg_snakeoil_17` PIGSTY 1.4	`pg_snakeoil_16` PIGSTY 1.4	`pg_snakeoil_15` PIGSTY 1.4	`pg_snakeoil_14` PIGSTY 1.4	`pg_snakeoil_13` PIGSTY 1.4
`el9`	`aarch64`	`pg_snakeoil_17` PIGSTY 1.4	`pg_snakeoil_16` PIGSTY 1.4	`pg_snakeoil_15` PIGSTY 1.4	`pg_snakeoil_14` PIGSTY 1.4	`pg_snakeoil_13` PIGSTY 1.4
`d12`	`x86_64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4
`d12`	`aarch64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4
`u22`	`x86_64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4
`u22`	`aarch64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4
`u24`	`x86_64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4
`u24`	`aarch64`	`postgresql-17-snakeoil` PGDG 1.4	`postgresql-16-snakeoil` PGDG 1.4	`postgresql-15-snakeoil` PGDG 1.4	`postgresql-14-snakeoil` PGDG 1.4	`postgresql-13-snakeoil` PGDG 1.4

Installation

Install pg_snakeoil via the pig CLI tool:

pig ext install pg_snakeoil

Install pg_snakeoil via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_snakeoil"]}' # -l <cls>

Install pg_snakeoil RPM from YUM repo directly:

dnf install pg_snakeoil_17*;
dnf install pg_snakeoil_16*;
dnf install pg_snakeoil_15*;
dnf install pg_snakeoil_14*;
dnf install pg_snakeoil_13*;

Install pg_snakeoil DEB from APT repo directly:

apt install postgresql-17-snakeoil;
apt install postgresql-16-snakeoil;
apt install postgresql-15-snakeoil;
apt install postgresql-14-snakeoil;
apt install postgresql-13-snakeoil;

Extension pg_snakeoil has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pg_snakeoil'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

19 - pgextwlist

PostgreSQL Extension Whitelisting

Overview

PIGSTY 3rd Party Extension: pgextwlist : PostgreSQL Extension Whitelisting

Information

Extension ID: 7180
Extension Name: pgextwlist
Package Name: pgextwlist
Category: SEC
License: PostgreSQL
Website: https://github.com/dimitri/pgextwlist
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.17
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pgextwlist_$v*
RPM Ver : 1.17
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgextwlist
DEB Ver : 1.17
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgextwlist_17` PIGSTY 1.17	`pgextwlist_16` PIGSTY 1.17	`pgextwlist_15` PIGSTY 1.17	`pgextwlist_14` PIGSTY 1.17	`pgextwlist_13` PIGSTY 1.17
`el8`	`aarch64`	`pgextwlist_17` PIGSTY 1.17	`pgextwlist_16` PIGSTY 1.17	`pgextwlist_15` PIGSTY 1.17	`pgextwlist_14` PIGSTY 1.17	`pgextwlist_13` PIGSTY 1.17
`el9`	`x86_64`	`pgextwlist_17` PIGSTY 1.17	`pgextwlist_16` PIGSTY 1.17	`pgextwlist_15` PIGSTY 1.17	`pgextwlist_14` PIGSTY 1.17	`pgextwlist_13` PIGSTY 1.17
`el9`	`aarch64`	`pgextwlist_17` PIGSTY 1.17	`pgextwlist_16` PIGSTY 1.17	`pgextwlist_15` PIGSTY 1.17	`pgextwlist_14` PIGSTY 1.17	`pgextwlist_13` PIGSTY 1.17
`d12`	`x86_64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18
`d12`	`aarch64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18
`u22`	`x86_64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18
`u22`	`aarch64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18
`u24`	`x86_64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18
`u24`	`aarch64`	`postgresql-17-pgextwlist` PGDG 1.18	`postgresql-16-pgextwlist` PGDG 1.18	`postgresql-15-pgextwlist` PGDG 1.18	`postgresql-14-pgextwlist` PGDG 1.18	`postgresql-13-pgextwlist` PGDG 1.18

Installation

Install pgextwlist via the pig CLI tool:

pig ext install pgextwlist

Install pgextwlist via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgextwlist"]}' # -l <cls>

Install pgextwlist RPM from YUM repo directly:

dnf install pgextwlist_17*;
dnf install pgextwlist_16*;
dnf install pgextwlist_15*;
dnf install pgextwlist_14*;
dnf install pgextwlist_13*;

Install pgextwlist DEB from APT repo directly:

apt install postgresql-17-pgextwlist;
apt install postgresql-16-pgextwlist;
apt install postgresql-15-pgextwlist;
apt install postgresql-14-pgextwlist;
apt install postgresql-13-pgextwlist;

Extension pgextwlist has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pgextwlist'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

20 - pg_auditor

Audit data changes and provide flashback ability

Overview

PIGSTY 3rd Party Extension: pg_auditor : Audit data changes and provide flashback ability

Information

Extension ID: 7190
Extension Name: pg_auditor
Package Name: pg_auditor
Category: SEC
License: BSD 3
Website: https://github.com/kouber/pg_auditor
Language: SQL
Extra Tags: N/A
Comment:

Metadata

Latest Version: 0.2
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Unknown
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_auditor_$v
RPM Ver : 0.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-auditor
DEB Ver : 0.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_auditor_17` PIGSTY 0.2	`pg_auditor_16` PIGSTY 0.2	`pg_auditor_15` PIGSTY 0.2	`pg_auditor_14` PIGSTY 0.2	`pg_auditor_13` PIGSTY 0.2
`el8`	`aarch64`	`pg_auditor_17` PIGSTY 0.2	`pg_auditor_16` PIGSTY 0.2	`pg_auditor_15` PIGSTY 0.2	`pg_auditor_14` PIGSTY 0.2	`pg_auditor_13` PIGSTY 0.2
`el9`	`x86_64`	`pg_auditor_17` PIGSTY 0.2	`pg_auditor_16` PIGSTY 0.2	`pg_auditor_15` PIGSTY 0.2	`pg_auditor_14` PIGSTY 0.2	`pg_auditor_13` PIGSTY 0.2
`el9`	`aarch64`	`pg_auditor_17` PIGSTY 0.2	`pg_auditor_16` PIGSTY 0.2	`pg_auditor_15` PIGSTY 0.2	`pg_auditor_14` PIGSTY 0.2	`pg_auditor_13` PIGSTY 0.2
`d12`	`x86_64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2
`d12`	`aarch64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2
`u22`	`x86_64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2
`u22`	`aarch64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2
`u24`	`x86_64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2
`u24`	`aarch64`	`postgresql-17-pg-auditor` PIGSTY 0.2	`postgresql-16-pg-auditor` PIGSTY 0.2	`postgresql-15-pg-auditor` PIGSTY 0.2	`postgresql-14-pg-auditor` PIGSTY 0.2	`postgresql-13-pg-auditor` PIGSTY 0.2

Installation

Install pg_auditor via the pig CLI tool:

pig ext install pg_auditor

Install pg_auditor via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_auditor"]}' # -l <cls>

Install pg_auditor RPM from YUM repo directly:

dnf install pg_auditor_17;
dnf install pg_auditor_16;
dnf install pg_auditor_15;
dnf install pg_auditor_14;
dnf install pg_auditor_13;

Install pg_auditor DEB from APT repo directly:

apt install postgresql-17-pg-auditor;
apt install postgresql-16-pg-auditor;
apt install postgresql-15-pg-auditor;
apt install postgresql-14-pg-auditor;
apt install postgresql-13-pg-auditor;

Create pg_auditor extension on PostgreSQL cluster:

CREATE EXTENSION pg_auditor;

21 - sslutils

A Postgres extension for managing SSL certificates through SQL

Overview

PIGSTY 3rd Party Extension: sslutils : A Postgres extension for managing SSL certificates through SQL

Information

Extension ID: 7200
Extension Name: sslutils
Package Name: sslutils
Category: SEC
License: PostgreSQL
Website: https://github.com/EnterpriseDB/sslutils
Language: C
Extra Tags: pgdg-flaw
Comment:

Metadata

Latest Version: 1.4
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: sslutils_$v*
RPM Ver : 1.4
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-sslutils
DEB Ver : 1.4
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`sslutils_17` PIGSTY 1.4	`sslutils_16` PIGSTY 1.4	`sslutils_15` PIGSTY 1.4	`sslutils_14` PIGSTY 1.4	`sslutils_13` PIGSTY 1.4
`el8`	`aarch64`	`sslutils_17` PIGSTY 1.4	`sslutils_16` PIGSTY 1.4	`sslutils_15` PIGSTY 1.4	`sslutils_14` PIGSTY 1.4	`sslutils_13` PIGSTY 1.4
`el9`	`x86_64`	`sslutils_17` PIGSTY 1.4	`sslutils_16` PIGSTY 1.4	`sslutils_15` PIGSTY 1.4	`sslutils_14` PIGSTY 1.4	`sslutils_13` PIGSTY 1.4
`el9`	`aarch64`	`sslutils_17` PIGSTY 1.4	`sslutils_16` PIGSTY 1.4	`sslutils_15` PIGSTY 1.4	`sslutils_14` PIGSTY 1.4	`sslutils_13` PIGSTY 1.4
`d12`	`x86_64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4
`d12`	`aarch64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4
`u22`	`x86_64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4
`u22`	`aarch64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4
`u24`	`x86_64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4
`u24`	`aarch64`	`postgresql-17-sslutils` PIGSTY 1.4	`postgresql-16-sslutils` PIGSTY 1.4	`postgresql-15-sslutils` PIGSTY 1.4	`postgresql-14-sslutils` PIGSTY 1.4	`postgresql-13-sslutils` PIGSTY 1.4

Installation

Install sslutils via the pig CLI tool:

pig ext install sslutils

Install sslutils via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["sslutils"]}' # -l <cls>

Install sslutils RPM from YUM repo directly:

dnf install sslutils_17*;
dnf install sslutils_16*;
dnf install sslutils_15*;
dnf install sslutils_14*;
dnf install sslutils_13*;

Install sslutils DEB from APT repo directly:

apt install postgresql-17-sslutils;
apt install postgresql-16-sslutils;
apt install postgresql-15-sslutils;
apt install postgresql-14-sslutils;
apt install postgresql-13-sslutils;

Create sslutils extension on PostgreSQL cluster:

CREATE EXTENSION sslutils;

22 - noset

Module for blocking SET variables for non-super users.

Overview

PIGSTY 3rd Party Extension: pg_noset : Module for blocking SET variables for non-super users.

Information

Extension ID: 7210
Extension Name: noset
Package Name: pg_noset
Category: SEC
License: AGPLv3
Website: https://gitlab.com/ongresinc/extensions/noset
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.3.0
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Unknown
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: noset_$v*
RPM Ver : 0.3.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-noset
DEB Ver : 0.3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`noset_17` PIGSTY 0.3.0	`noset_16` PIGSTY 0.3.0	`noset_15` PIGSTY 0.3.0	`noset_14` PIGSTY 0.3.0	`noset_13` PIGSTY 0.3.0
`el8`	`aarch64`	`noset_17` PIGSTY 0.3.0	`noset_16` PIGSTY 0.3.0	`noset_15` PIGSTY 0.3.0	`noset_14` PIGSTY 0.3.0	`noset_13` PIGSTY 0.3.0
`el9`	`x86_64`	`noset_17` PIGSTY 0.3.0	`noset_16` PIGSTY 0.3.0	`noset_15` PIGSTY 0.3.0	`noset_14` PIGSTY 0.3.0	`noset_13` PIGSTY 0.3.0
`el9`	`aarch64`	`noset_17` PIGSTY 0.3.0	`noset_16` PIGSTY 0.3.0	`noset_15` PIGSTY 0.3.0	`noset_14` PIGSTY 0.3.0	`noset_13` PIGSTY 0.3.0
`d12`	`x86_64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0
`d12`	`aarch64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0
`u22`	`x86_64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0
`u22`	`aarch64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0
`u24`	`x86_64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0
`u24`	`aarch64`	`postgresql-17-noset` PIGSTY 0.3.0	`postgresql-16-noset` PIGSTY 0.3.0	`postgresql-15-noset` PIGSTY 0.3.0	`postgresql-14-noset` PIGSTY 0.3.0	`postgresql-13-noset` PIGSTY 0.3.0

Installation

Install noset via the pig CLI tool:


pig ext install pg_noset; 	# Extension Name
pig ext install noset; 	# normalized package name

Install pg_noset via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_noset"]}' # -l <cls>

Install pg_noset RPM from YUM repo directly:

dnf install noset_17*;
dnf install noset_16*;
dnf install noset_15*;
dnf install noset_14*;
dnf install noset_13*;

Install pg_noset DEB from APT repo directly:

apt install postgresql-17-noset;
apt install postgresql-16-noset;
apt install postgresql-15-noset;
apt install postgresql-14-noset;
apt install postgresql-13-noset;

Extension noset has to be loaded via shared_preload_libraries

shared_preload_libraries = 'noset'; # add to pg cluster config

Create noset extension on PostgreSQL cluster:

CREATE EXTENSION noset;

23 - sepgsql

label-based mandatory access control (MAC) based on SELinux security policy.

Overview

CONTRIB Built-in Extension: sepgsql : label-based mandatory access control (MAC) based on SELinux security policy.

Information

Extension ID: 7960
Extension Name: sepgsql
Package Name: None
Category: SEC
License: PostgreSQL
Website: https://www.postgresql.org/docs/current/sepgsql.html
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: -
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`
`d12`	`aarch64`
`u22`	`x86_64`
`u22`	`aarch64`
`u24`	`x86_64`
`u24`	`aarch64`

Installation

Extension sepgsql is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install sepgsql RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install sepgsql DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Extension sepgsql has to be loaded via shared_preload_libraries

shared_preload_libraries = 'sepgsql'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

24 - auth_delay

pause briefly before reporting authentication failure

Overview

CONTRIB Built-in Extension: auth_delay : pause briefly before reporting authentication failure

Information

Extension ID: 7970
Extension Name: auth_delay
Package Name: None
Category: SEC
License: PostgreSQL
Website: https://www.postgresql.org/docs/current/auth-delay.html
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: -
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`
`d12`	`aarch64`
`u22`	`x86_64`
`u22`	`aarch64`
`u24`	`x86_64`
`u24`	`aarch64`

Installation

Extension auth_delay is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install auth_delay RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install auth_delay DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Extension auth_delay has to be loaded via shared_preload_libraries

shared_preload_libraries = 'auth_delay'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

25 - pgcrypto

cryptographic functions

Overview

CONTRIB Built-in Extension: pgcrypto : cryptographic functions

Information

Extension ID: 7980
Extension Name: pgcrypto
Package Name: None
Category: SEC
License: PostgreSQL
Website: https://www.postgresql.org/docs/current/pgcrypto.html
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.3
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`
`d12`	`aarch64`
`u22`	`x86_64`
`u22`	`aarch64`
`u24`	`x86_64`
`u24`	`aarch64`

Installation

Extension pgcrypto is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install pgcrypto RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install pgcrypto DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Create pgcrypto extension on PostgreSQL cluster:

CREATE EXTENSION pgcrypto;

26 - passwordcheck

checks user passwords and reject weak password

Overview

CONTRIB Built-in Extension: passwordcheck : checks user passwords and reject weak password

Information

Extension ID: 7990
Extension Name: passwordcheck
Package Name: None
Category: SEC
License: PostgreSQL
Website: https://www.postgresql.org/docs/current/passwordcheck.html
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: -
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`
`d12`	`aarch64`
`u22`	`x86_64`
`u22`	`aarch64`
`u24`	`x86_64`
`u24`	`aarch64`

Installation

Extension passwordcheck is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install passwordcheck RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install passwordcheck DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Extension passwordcheck has to be loaded via shared_preload_libraries

shared_preload_libraries = 'passwordcheck'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command