Install pg_tde on Debian or Ubuntu¶

This page explains how to install pg_tde with Percona Distribution for PostgreSQL .

Check the list of supported platforms before continuing.

Preconditions¶

Debian and other systems that use the apt package manager include the upstream PostgreSQL server package (postgresql-17.5) by default. You need to uninstall this package before you install Percona Server for PostgreSQL and pg_tde to avoid conflicts.
You need the percona-release repository management tool that enables the desired Percona repository for you.

Install percona-release¶

You need the following dependencies to install percona-release:
- wget
- gnupg2
- curl
- lsb-release
Install them with the following command:
```
sudo apt-get install -y wget gnupg2 curl lsb-release
```

Fetch the percona-release package

sudo wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb

Install percona-release

sudo dpkg -i percona-release_latest.generic_all.deb

Enable the Percona Distribution for PostgreSQL repository
```
sudo percona-release enable-only ppg-17.5
```
Update the local cache
```
sudo apt-get update
```

Install pg_tde¶

Important

The pg_tde extension is a part of the percona-postgresql-17 package. If you installed a previous version of pg_tde from the percona-postgresql-17-pg-tde package, do the following:

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;
```
Uninstall the percona-postgresql-17-pg-tde package.

After all preconditions are met, run the following command to install pg_tde:

sudo apt-get install -y percona-postgresql-17

Next steps¶

Configure pg_tde