Install pg_tde on Red Hat Enterprise Linux and derivatives

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

Check the list of supported platforms.

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.

   $ sudo percona-release enable-only ppg-17.4 
   

Install pg_tde

Important

The pg_tde 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:

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

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

1. Uninstall the percona-pg_tde_17 package.

Run the following command to install pg_tde:

$ sudo yum -y install percona-postgresql17 

Next steps

Setup