Install pg_tde on Red Hat Enterprise Linux and Derivatives

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

Make sure you check the list of supported platforms before continuing.

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.5
   

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-server percona-postgresql17-contrib 

Next steps

Configure pg_tde