How to drop unused partition

Hey @nguyenthanhquang152,

You should be able to set the number of partitions you want to keep, then execute the run_maintenance() function to automatically drop (or archive) the old data.

It does require additional GRANTS on a per-database basis to be able to do so, as you’ve done here.

I don’t know what roles will exist and don’t want to grant permissions that may not be wanted by default.

CREATE ROLE partman WITH LOGIN;
GRANT ALL ON SCHEMA partman TO partman;
GRANT ALL ON ALL TABLES IN SCHEMA partman TO partman;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA partman TO partman;
GRANT EXECUTE ON ALL PROCEDURES IN SCHEMA partman TO partman;  -- PG11+ only
GRANT ALL ON SCHEMA my_partition_schema TO partman;

You will tell me how it goes.

Cheers, - Sergio Turpín