Comment by lovasoa

Comment by lovasoa 20 hours ago

3 replies

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.

heeton 15 hours ago

It allows updating the original data - https://postgresql-anonymizer.readthedocs.io/en/stable/stati...

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

  • sgt 10 hours ago

    So basically running SELECT anon.anonymize_database(); will do it.

    • daamien 4 hours ago

      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.