Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: Hosney Osman <hosneybinosman(at)gmail(dot)com>
Cc: Alastair Turner <minion(at)decodable(dot)me>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL
Date: 2024-10-30 19:47:16
Message-ID: CAFcOn2-1JbYMbR_9N9QSyS8815vzsuyMSPjguz_0w4quUtNx8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Osman

See postgresql_anonymizer
https://gitlab.com/dalibo/postgresql_anonymizer/ and pg_anonymize
https://github.com/rjuju/pg_anonymize , where the former has more
functionality, like synthetic data generation (if you need that).

Yours, Stefan

Am Di., 29. Okt. 2024 um 10:01 Uhr schrieb Hosney Osman
<hosneybinosman(at)gmail(dot)com>:
>
> could you please provide me with reference or article or example for this scenario
> for example i have schema include 4 table
> and i want to anonymize it in another schema
> how to do that
>
> On Wed, Oct 23, 2024 at 4:25 PM Alastair Turner <minion(at)decodable(dot)me> wrote:
>>
>> Hi Hosney
>>
>> On Wed, 23 Oct 2024, 15:17 Hosney Osman, <hosneybinosman(at)gmail(dot)com> wrote:
>>>
>>> Dear PostgreSQL Development Team,
>>>
>>> I am writing to propose the development of native data masking and anonymization features within PostgreSQL. As a long-time user of PostgreSQL,
>>>
>>> I have observed a growing need for efficient and secure data handling, particularly in compliance with regulations like GDPR
>>
>> This requirement already seems to be well served by extensions. pg_anonymize, for instance, uses the meta data tools available in the database, like security labels, to manage the values returned to users.
>>
>> Is there any functionality, or usability, in this area which you believe can't be delivered by an extension?
>>
>> Regards
>>
>> Alastair

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2024-10-30 19:49:54 Re: protocol-level wait-for-LSN
Previous Message David Fetter 2024-10-30 19:27:40 Shave a few cycles off our ilog10 implementation