Re: encrypting data stored in PostgreSQL

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	Re: encrypting data stored in PostgreSQL
Дата	9 апреля 2014 г. 21:17:24
Msg-id	CAD3a31VHdLG7t+EwkDOQZ8kC8nGDNiWRkj-czi515qShBSVzHQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: encrypting data stored in PostgreSQL (Rob Sargent <robjsargent@gmail.com>)
Ответы	Re: encrypting data stored in PostgreSQL Re: encrypting data stored in PostgreSQL
Список	pgsql-general

Дерево обсуждения

On 04/09/2014 02:52 PM, John R Pierce wrote:
On 4/9/2014 1:40 PM, CS_DBA wrote:
Hi All;

We have a client with this requirement:

At rest data must be encrypted with a unique client key

Any thoughts on how to pull this off for PostgreSQL stored data?

I looked at this a while ago because I have clients who might require this in the future. ISTM you should be able to have your PG data directory stored on an encrypted filesystem. I believe this will decrease performance, but I have no idea by how much.

Does anyone else have experience with such a setup, or knowledge of how bad the performance hit might be? Or other factors to take into consideration? Thanks.

Ken