Re: PG Database Encryption

Поиск
Список
Период
Сортировка
От Ravi GH
Тема Re: PG Database Encryption
Дата
Msg-id CABeo-VNUScfh_PpDs7CutsWBnCiYw3=00z2XUO=iedVB+tiCCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG Database Encryption  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: PG Database Encryption
Список pgsql-admin
Thanks depesz , Ron, Marco & others,

I tried the suggested option of TDE , to enable Cluster Level Encryption. I had followed the  "Installation from Source Code" method with --with-ssl=openssl parameter to ./configure during build.

1. Please confirm the enabling encryption is possible only by install from source with --with-ssl parameter?
2. I could enable encryption using PG 12 with patched version provided at here , do we need to purchase the product or is it possible with Postgres source shared at https://www.postgresql.org/ftp/source/v14.7/

We are using Ubuntu 22 and we will prefer to go with TDE cluster level encryption, please advise can we try to implement it by install from source ( with shared source at https://www.postgresql.org/ftp/source/v14.7 ) or need to purchasing TDE patched version is mandatory to enable cluster level encryption?

Thanks a lot,
Ravi


On Thu, May 25, 2023 at 3:52 PM hubert depesz lubaczewski <depesz@depesz.com> wrote:
On Thu, May 25, 2023 at 01:51:53PM +0530, Ravi GH wrote:
> Seeking guidance in this regard on How to enable DataBase Encryption of
> Postgresql DB. Can anyone guide me in this regard or share a few pointers
> pages on "How to enable it" or any 3rd party tools that can do ths.

Pg doesn't have anything like this now.

What you can do, is:
1. Check https://wiki.postgresql.org/wiki/Transparent_Data_Encryption
2. Encrypt the filesystem/disk that the PG is on, using whatever tool
   your operating system provides.

Best regards,

depesz



--
"Give me the place to stand, and I shall move the earth" — Archimedes

В списке pgsql-admin по дате отправления:

Предыдущее
От: Victor Sudakov
Дата:
Сообщение: xlog min recovery request 7C5C/96D5C550 is past current point
Следующее
От: easoftware@gmail.com
Дата:
Сообщение: Fatal Error when starting PgAdmin