←back to thread

PostgreSQL Anonymizer

(postgresql-anonymizer.readthedocs.io)
243 points chynkm | 1 comments | 14 Jan 25 07:36 UTC | HN request time: 0.215s | source
Show context
sgt ◴[17 Jan 25 08:08 UTC] No.42735168[source]▶
Just be careful that you don't anonymize your production data.
replies(3): >>42735222 #>>42735455 #>>42735797 #
lovasoa ◴[17 Jan 25 08:59 UTC] No.42735455[source]▶
The principle of the software seems to be that the original data is never altered. It is a postgres extension that "masks" the data for certain postgres users. You can always connect as the root user and see everything when you need to.
replies(1): >>42737584 #
heeton ◴[17 Jan 25 14:02 UTC] No.42737584[source]▶
It allows updating the original data - https://postgresql-anonymizer.readthedocs.io/en/stable/stati...

> These methods will destroy the original data. Use with care.

replies(1): >>42741999 #
sgt ◴[17 Jan 25 19:02 UTC] No.42741999[source]▶
So basically running SELECT anon.anonymize_database(); will do it.
replies(1): >>42744737 #
1. daamien ◴[18 Jan 25 00:42 UTC] No.42744737[source]▶
Both approach are possible

* Static Masking will destroy the authentic data once for all

* Dynamic Masking will only alter the data the "masked users". Regular users will continue to view the real data.

Both techniques have their own advantage depending on your context.