From: Kai Wagner <kai.wagner@percona.com>
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgres database encryption
Date: Tue, 19 Mar 2024 19:20:26 +0100
Message-ID: <3adaed22-5e25-4c12-964b-65e70b0c9217@percona.com> (raw)
In-Reply-To: <CACoPQdZ01+ixC5Yq7M=wuVj+TxqzxF457+BSCoJbEq-rS-LrWg@mail.gmail.com>
References: <CACoPQdZ01+ixC5Yq7M=wuVj+TxqzxF457+BSCoJbEq-rS-LrWg@mail.gmail.com>
Hey,
On 19/03/2024 14:22, Johnathan Tiamoh wrote:
> Hello,
>
>
> Good morning. Please I wish to find out the best way of encrypting a
> Postgres database.
>
> This could either be encrypting a whole database ( I don’t if this is
> possible), a specific table and a specific tablespace.
There is no default incore mechanism to do that. Depending on your treat
vector, OS-Level could be fine or you need to go with any of the incore
rebuilds available by some vendors.
We're currently working on another mechanism, which enables you to
encrypt on a table level. Of course, completely open source project,
available on GitHub https://github.com/Percona-Lab/pg_tde
Would be happy, if you can give it a shot, and share your thoughts and
feedback.
>
>
> King regards
> Johnathan T.
--
Kai Wagner
Sr. Engineering Manager, Percona
e: kai.wagner@percona.com
w: www.percona.com
Databases Run Better with Percona.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: kai.wagner@percona.com, johnathantiamoh@gmail.com
Subject: Re: Postgres database encryption
In-Reply-To: <3adaed22-5e25-4c12-964b-65e70b0c9217@percona.com>
References: <CACoPQdZ01+ixC5Yq7M=wuVj+TxqzxF457+BSCoJbEq-rS-LrWg@mail.gmail.com> <3adaed22-5e25-4c12-964b-65e70b0c9217@percona.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox