runbooks/9-conclusion

Conclusion

Clean up !

The Anonymized Replica tutorial created a second database with a subscription that holds a replication slot on boutique. We drop the subscription first, otherwise boutique could not be dropped. (If you skipped that tutorial, skip the next two blocks.)

DROP SUBSCRIPTION IF EXISTS sub_boutique;

DROP DATABASE IF EXISTS boutique_replica WITH (FORCE);

DROP DATABASE IF EXISTS boutique WITH (FORCE);

REASSIGN OWNED BY jack TO postgres;

REASSIGN OWNED BY paul TO postgres;

REASSIGN OWNED BY pierre TO postgres;

DROP ROLE IF EXISTS jack;
DROP ROLE IF EXISTS paul;
DROP ROLE IF EXISTS pierre;
DROP ROLE IF EXISTS dump_anon;
DROP ROLE IF EXISTS anon_replicator;

Also…

Other projects you may like

• pg_sample : extract a small dataset from a larger PostgreSQL database

Help Wanted!

This is a free and open project!

labs.dalibo.com/postgresql_anonymizer

Please send us feedback on how you use it, how it fits your needs (or not), etc.