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.
-
Install
percona-release
:sudo yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
-
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:
- Drop the extension using the
DROP EXTENSION
withCASCADE
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
- 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