[go: up one dir, main page]
Skip to content

Question regarding the "Anonymizing an SQL file" flow

Hello,

I have a question regarding the "Anonymizing an SQL file" flow, also known as the "anonymizing black box" approach.

Is this method designed to work on a database dump from a system that does not have postgresql_anonymizer installed? My intended process is:

  1. Generate a database dump from a PostgreSQL database without the anonymizer extension installed. 2.Transform the dump using anonymization rules as described in the documentation.
  2. Load the anonymized dump into another database.

Is this workflow expected to work? In my initial attempt, I was able to get MASKED WITH VALUE to work, but MASKED WITH FUNCTION did not.

Any insights would be greatly appreciated.

Thanks!

Edited by Rémi Pradal
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information