Extensions
sslutils

sslutils

sslutils : A Postgres extension for managing SSL certificates through SQL

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
7410
sslutils
sslutils
1.4
SEC
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
sslinfo
pgsodium
pgsmcrypto
pgcryptokey
pgcrypto
pg_tde
passwordcheck_cracklib
supautils

no pg15,14 on el9, no pg18 on el8

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
PIGSTY
1.4
18
17
16
15
14
sslutils-
RPM
PIGSTY
1.4
18
17
16
15
14
sslutils_$v-
DEB
PIGSTY
1.4
18
17
16
15
14
postgresql-$v-sslutils-
Linux / PGPG18PG17PG16PG15PG14
el8.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
el8.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
el9.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
el9.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
el10.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
el10.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
d12.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
d12.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
d13.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
d13.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
u22.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
u22.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
u24.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
u24.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PackageVersionOSORGSIZEFile URL
sslutils_181.4el8.x86_64pigsty24.4 KiBsslutils_18-1.4-1PIGSTY.el8.x86_64.rpm
sslutils_181.4el8.aarch64pigsty23.5 KiBsslutils_18-1.4-1PIGSTY.el8.aarch64.rpm
sslutils_181.4el9.x86_64pigsty24.8 KiBsslutils_18-1.4-2PIGSTY.el9.x86_64.rpm
sslutils_181.4el9.x86_64pgdg24.5 KiBsslutils_18-1.4-2PGDG.rhel9.x86_64.rpm
sslutils_181.4el9.aarch64pigsty23.8 KiBsslutils_18-1.4-2PIGSTY.el9.aarch64.rpm
sslutils_181.4el9.aarch64pgdg23.2 KiBsslutils_18-1.4-2PGDG.rhel9.aarch64.rpm
sslutils_181.4el10.x86_64pigsty25.8 KiBsslutils_18-1.4-2PIGSTY.el10.x86_64.rpm
sslutils_181.4el10.x86_64pgdg25.6 KiBsslutils_18-1.4-2PGDG.rhel10.x86_64.rpm
sslutils_181.4el10.aarch64pigsty24.7 KiBsslutils_18-1.4-2PIGSTY.el10.aarch64.rpm
sslutils_181.4el10.aarch64pgdg24.4 KiBsslutils_18-1.4-2PGDG.rhel10.aarch64.rpm
postgresql-18-sslutils1.4d12.x86_64pigsty37.2 KiBpostgresql-18-sslutils_1.4-2PIGSTY~bookworm_amd64.deb
postgresql-18-sslutils1.4d12.aarch64pigsty35.6 KiBpostgresql-18-sslutils_1.4-2PIGSTY~bookworm_arm64.deb
postgresql-18-sslutils1.4d13.x86_64pigsty37.8 KiBpostgresql-18-sslutils_1.4-2PIGSTY~trixie_amd64.deb
postgresql-18-sslutils1.4d13.aarch64pigsty36.1 KiBpostgresql-18-sslutils_1.4-2PIGSTY~trixie_arm64.deb
postgresql-18-sslutils1.4u22.x86_64pigsty40.1 KiBpostgresql-18-sslutils_1.4-2PIGSTY~jammy_amd64.deb
postgresql-18-sslutils1.4u22.aarch64pigsty38.9 KiBpostgresql-18-sslutils_1.4-2PIGSTY~jammy_arm64.deb
postgresql-18-sslutils1.4u24.x86_64pigsty39.4 KiBpostgresql-18-sslutils_1.4-2PIGSTY~noble_amd64.deb
postgresql-18-sslutils1.4u24.aarch64pigsty38.1 KiBpostgresql-18-sslutils_1.4-2PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
sslutils_171.4el8.x86_64pigsty24.5 KiBsslutils_17-1.4-2PIGSTY.el8.x86_64.rpm
sslutils_171.4el8.x86_64pgdg24.5 KiBsslutils_17-1.4-1PGDG.rhel8.x86_64.rpm
sslutils_171.4el8.aarch64pigsty23.6 KiBsslutils_17-1.4-2PIGSTY.el8.aarch64.rpm
sslutils_171.4el8.aarch64pgdg23.4 KiBsslutils_17-1.4-1PGDG.rhel8.aarch64.rpm
sslutils_171.4el9.x86_64pigsty24.8 KiBsslutils_17-1.4-2PIGSTY.el9.x86_64.rpm
sslutils_171.4el9.x86_64pgdg24.4 KiBsslutils_17-1.4-1PGDG.rhel9.x86_64.rpm
sslutils_171.4el9.aarch64pigsty23.8 KiBsslutils_17-1.4-2PIGSTY.el9.aarch64.rpm
sslutils_171.4el9.aarch64pgdg23.3 KiBsslutils_17-1.4-1PGDG.rhel9.aarch64.rpm
sslutils_171.4el10.x86_64pigsty25.8 KiBsslutils_17-1.4-2PIGSTY.el10.x86_64.rpm
sslutils_171.4el10.x86_64pgdg25.6 KiBsslutils_17-1.4-2PGDG.rhel10.x86_64.rpm
sslutils_171.4el10.aarch64pigsty24.7 KiBsslutils_17-1.4-2PIGSTY.el10.aarch64.rpm
sslutils_171.4el10.aarch64pgdg24.4 KiBsslutils_17-1.4-2PGDG.rhel10.aarch64.rpm
postgresql-17-sslutils1.4d12.x86_64pigsty36.9 KiBpostgresql-17-sslutils_1.4-2PIGSTY~bookworm_amd64.deb
postgresql-17-sslutils1.4d12.aarch64pigsty35.5 KiBpostgresql-17-sslutils_1.4-2PIGSTY~bookworm_arm64.deb
postgresql-17-sslutils1.4d13.x86_64pigsty37.5 KiBpostgresql-17-sslutils_1.4-2PIGSTY~trixie_amd64.deb
postgresql-17-sslutils1.4d13.aarch64pigsty36.1 KiBpostgresql-17-sslutils_1.4-2PIGSTY~trixie_arm64.deb
postgresql-17-sslutils1.4u22.x86_64pigsty42.8 KiBpostgresql-17-sslutils_1.4-2PIGSTY~jammy_amd64.deb
postgresql-17-sslutils1.4u22.aarch64pigsty41.7 KiBpostgresql-17-sslutils_1.4-2PIGSTY~jammy_arm64.deb
postgresql-17-sslutils1.4u24.x86_64pigsty39.4 KiBpostgresql-17-sslutils_1.4-2PIGSTY~noble_amd64.deb
postgresql-17-sslutils1.4u24.aarch64pigsty38.1 KiBpostgresql-17-sslutils_1.4-2PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
sslutils_161.4el8.x86_64pigsty24.5 KiBsslutils_16-1.4-2PIGSTY.el8.x86_64.rpm
sslutils_161.4el8.x86_64pgdg24.5 KiBsslutils_16-1.4-1PGDG.rhel8.x86_64.rpm
sslutils_161.4el8.aarch64pigsty23.6 KiBsslutils_16-1.4-2PIGSTY.el8.aarch64.rpm
sslutils_161.4el8.aarch64pgdg23.4 KiBsslutils_16-1.4-1PGDG.rhel8.aarch64.rpm
sslutils_161.4el9.x86_64pigsty24.8 KiBsslutils_16-1.4-2PIGSTY.el9.x86_64.rpm
sslutils_161.4el9.x86_64pgdg24.4 KiBsslutils_16-1.4-1PGDG.rhel9.x86_64.rpm
sslutils_161.4el9.aarch64pigsty23.8 KiBsslutils_16-1.4-2PIGSTY.el9.aarch64.rpm
sslutils_161.4el9.aarch64pgdg23.3 KiBsslutils_16-1.4-1PGDG.rhel9.aarch64.rpm
sslutils_161.4el10.x86_64pigsty25.8 KiBsslutils_16-1.4-2PIGSTY.el10.x86_64.rpm
sslutils_161.4el10.x86_64pgdg25.7 KiBsslutils_16-1.4-2PGDG.rhel10.x86_64.rpm
sslutils_161.4el10.aarch64pigsty24.7 KiBsslutils_16-1.4-2PIGSTY.el10.aarch64.rpm
sslutils_161.4el10.aarch64pgdg24.4 KiBsslutils_16-1.4-2PGDG.rhel10.aarch64.rpm
postgresql-16-sslutils1.4d12.x86_64pigsty37.1 KiBpostgresql-16-sslutils_1.4-2PIGSTY~bookworm_amd64.deb
postgresql-16-sslutils1.4d12.aarch64pigsty35.5 KiBpostgresql-16-sslutils_1.4-2PIGSTY~bookworm_arm64.deb
postgresql-16-sslutils1.4d13.x86_64pigsty37.5 KiBpostgresql-16-sslutils_1.4-2PIGSTY~trixie_amd64.deb
postgresql-16-sslutils1.4d13.aarch64pigsty36.1 KiBpostgresql-16-sslutils_1.4-2PIGSTY~trixie_arm64.deb
postgresql-16-sslutils1.4u22.x86_64pigsty42.8 KiBpostgresql-16-sslutils_1.4-2PIGSTY~jammy_amd64.deb
postgresql-16-sslutils1.4u22.aarch64pigsty41.7 KiBpostgresql-16-sslutils_1.4-2PIGSTY~jammy_arm64.deb
postgresql-16-sslutils1.4u24.x86_64pigsty39.4 KiBpostgresql-16-sslutils_1.4-2PIGSTY~noble_amd64.deb
postgresql-16-sslutils1.4u24.aarch64pigsty38.1 KiBpostgresql-16-sslutils_1.4-2PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
sslutils_151.4el8.x86_64pigsty24.6 KiBsslutils_15-1.4-2PIGSTY.el8.x86_64.rpm
sslutils_151.3el8.x86_64pgdg49.4 KiBsslutils_15-1.3-4.rhel8.x86_64.rpm
sslutils_151.4el8.aarch64pigsty23.6 KiBsslutils_15-1.4-2PIGSTY.el8.aarch64.rpm
sslutils_151.4el9.x86_64pigsty24.8 KiBsslutils_15-1.4-2PIGSTY.el9.x86_64.rpm
sslutils_151.4el9.aarch64pigsty23.9 KiBsslutils_15-1.4-2PIGSTY.el9.aarch64.rpm
sslutils_151.4el10.x86_64pigsty25.8 KiBsslutils_15-1.4-2PIGSTY.el10.x86_64.rpm
sslutils_151.4el10.x86_64pgdg25.7 KiBsslutils_15-1.4-2PGDG.rhel10.x86_64.rpm
sslutils_151.4el10.aarch64pigsty24.8 KiBsslutils_15-1.4-2PIGSTY.el10.aarch64.rpm
sslutils_151.4el10.aarch64pgdg24.5 KiBsslutils_15-1.4-2PGDG.rhel10.aarch64.rpm
postgresql-15-sslutils1.4d12.x86_64pigsty37.0 KiBpostgresql-15-sslutils_1.4-2PIGSTY~bookworm_amd64.deb
postgresql-15-sslutils1.4d12.aarch64pigsty35.6 KiBpostgresql-15-sslutils_1.4-2PIGSTY~bookworm_arm64.deb
postgresql-15-sslutils1.4d13.x86_64pigsty37.5 KiBpostgresql-15-sslutils_1.4-2PIGSTY~trixie_amd64.deb
postgresql-15-sslutils1.4d13.aarch64pigsty36.1 KiBpostgresql-15-sslutils_1.4-2PIGSTY~trixie_arm64.deb
postgresql-15-sslutils1.4u22.x86_64pigsty42.9 KiBpostgresql-15-sslutils_1.4-2PIGSTY~jammy_amd64.deb
postgresql-15-sslutils1.4u22.aarch64pigsty41.7 KiBpostgresql-15-sslutils_1.4-2PIGSTY~jammy_arm64.deb
postgresql-15-sslutils1.4u24.x86_64pigsty39.5 KiBpostgresql-15-sslutils_1.4-2PIGSTY~noble_amd64.deb
postgresql-15-sslutils1.4u24.aarch64pigsty38.2 KiBpostgresql-15-sslutils_1.4-2PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
sslutils_141.4el8.x86_64pigsty24.5 KiBsslutils_14-1.4-2PIGSTY.el8.x86_64.rpm
sslutils_141.3el8.x86_64pgdg48.9 KiBsslutils_14-1.3-4.rhel8.x86_64.rpm
sslutils_141.4el8.aarch64pigsty23.6 KiBsslutils_14-1.4-2PIGSTY.el8.aarch64.rpm
sslutils_141.4el9.x86_64pigsty24.8 KiBsslutils_14-1.4-2PIGSTY.el9.x86_64.rpm
sslutils_141.4el9.aarch64pigsty23.8 KiBsslutils_14-1.4-2PIGSTY.el9.aarch64.rpm
sslutils_141.4el10.x86_64pigsty25.8 KiBsslutils_14-1.4-2PIGSTY.el10.x86_64.rpm
sslutils_141.4el10.x86_64pgdg25.8 KiBsslutils_14-1.4-2PGDG.rhel10.x86_64.rpm
sslutils_141.4el10.aarch64pigsty24.8 KiBsslutils_14-1.4-2PIGSTY.el10.aarch64.rpm
sslutils_141.4el10.aarch64pgdg24.5 KiBsslutils_14-1.4-2PGDG.rhel10.aarch64.rpm
postgresql-14-sslutils1.4d12.x86_64pigsty37.0 KiBpostgresql-14-sslutils_1.4-2PIGSTY~bookworm_amd64.deb
postgresql-14-sslutils1.4d12.aarch64pigsty35.5 KiBpostgresql-14-sslutils_1.4-2PIGSTY~bookworm_arm64.deb
postgresql-14-sslutils1.4d13.x86_64pigsty37.5 KiBpostgresql-14-sslutils_1.4-2PIGSTY~trixie_amd64.deb
postgresql-14-sslutils1.4d13.aarch64pigsty36.0 KiBpostgresql-14-sslutils_1.4-2PIGSTY~trixie_arm64.deb
postgresql-14-sslutils1.4u22.x86_64pigsty42.8 KiBpostgresql-14-sslutils_1.4-2PIGSTY~jammy_amd64.deb
postgresql-14-sslutils1.4u22.aarch64pigsty41.6 KiBpostgresql-14-sslutils_1.4-2PIGSTY~jammy_arm64.deb
postgresql-14-sslutils1.4u24.x86_64pigsty39.5 KiBpostgresql-14-sslutils_1.4-2PIGSTY~noble_amd64.deb
postgresql-14-sslutils1.4u24.aarch64pigsty38.2 KiBpostgresql-14-sslutils_1.4-2PIGSTY~noble_arm64.deb

Source

Repository
github.com/EnterpriseDB/sslutils
Source Tarball
sslutils-1.4.tar.gz
pig build pkg sslutils;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION sslutils;

Usage

sslutils: Manage SSL certificates through SQL

sslutils is a PostgreSQL extension for managing SSL certificates through SQL commands. It provides functions to generate, inspect, and manage SSL/TLS certificates directly within the database.

CREATE EXTENSION sslutils;

Functions

The extension provides SQL functions for SSL certificate management:

FunctionDescription
openssl_rsa_generate_key(bits int)Generate an RSA private key
openssl_rsa_key_to_csr(key text, cn text, ...)Generate a Certificate Signing Request
openssl_csr_to_crt(csr text, ca_key text, ca_crt text)Sign a CSR to produce a certificate
openssl_rsa_generate_crl(ca_key text, ca_crt text)Generate a Certificate Revocation List
ssl_is_init_fn()Check if SSL is initialized
ssl_get_cipher_fn()Get current SSL cipher
ssl_get_version_fn()Get current SSL version

Typical Workflow 

-- Generate a CA private key
SELECT openssl_rsa_generate_key(2048);

-- Create a self-signed CA certificate
-- Generate server key and CSR
-- Sign the CSR with the CA

This extension is useful for automating SSL certificate provisioning in managed PostgreSQL environments.

Last updated on
pgextwlistnoset