Install pg_tde on Red Hat Enterprise Linux and derivatives

The packages for the tech preview pg_tde are available in the experimental repository for Percona Distribution for PostgreSQL 17.

Check the list of supported platforms.

This tutorial shows how to install pg_tde with Percona Distribution for PostgreSQL.

Preconditions

Install percona-release

You need the percona-release repository management tool that enables the desired Percona repository for you.

1. Install percona-release:

   sudo yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm 
   

2. Enable the repository.

   Percona provides two repositories for Percona Distribution for PostgreSQL. We recommend enabling the Major release repository to timely receive the latest updates.

   sudo percona-release enable-only ppg-17.2 
   

Install pg_tde

Important

The pg_tde Beta extension is a part of the percona-postgresql17 package. If you installed a previous version of pg_tde from the percona-pg_tde_17 package, do the following:

• Drop the extension using the DROP EXTENSION with CASCADE command.

Warning: The use of the CASCADE parameter deletes all tables that were created in the database with pg_tde enabled and also all dependencies upon the encrypted table (e.g. foreign keys in a non-encrypted table used in the encrypted one).

DROP EXTENSION pg_tde CASCADE

• Uninstall the percona-pg_tde_17 package.

sudo yum -y install percona-postgresql17 

Next steps

Setup

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert