pg_tde

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

Packages

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 added to shared_preload_libraries

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

Enable pg_tde extension on PostgreSQL cluster：

CREATE EXTENSION pg_tde;