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