Install pg_tde on Debian or Ubuntu

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

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

Install percona-release

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

2. Fetch the percona-release package

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

3. Install percona-release

   sudo dpkg -i percona-release_latest.generic_all.deb
   

4. Enable the Percona Distribution for PostgreSQL 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 ppg-17.2 
   

5. Update the local cache

   sudo apt-get update
   

Install pg_tde

Important

The pg_tde Beta 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.

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

Setup

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert