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 Beta2 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