Skip to content

Error when running postgresql_anonymizer in blackbox with a cloud sql dump

Hello,

Since a few days ago, i am facing the following error when trying to apply the blackbox flow against a GCP cloud sql dump.

pg_dump: error: query failed: ERROR:  schema "anon" does not exist
pg_dump: detail: Query was: SELECT last_value, is_called FROM public.account_id_seq

This is weird because it used to work like a charm before.

I am running the blackbox like this:

cat dump.sql rules.sql| docker run --rm -i registry.gitlab.com/dalibo/postgresql_anonymizer /dump.sh > anon.sql

And a minimal rules.sql that can make the error appear is :

SELECT pg_catalog.set_config('search_path', 'public', false);

CREATE EXTENSION anon CASCADE;
SELECT anon.init();

Any idea why this happening ? And how i can help you investigate this problem ?

Thanks

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information