Hi Grass,
There is a known issue where the secondary mgmt's root partition runs full. I got TAC involved whereby the provided a wrapper hotfix to be install on the secondary mgmt only. They also advised me to upgrade to R81.20 take 26 which we did a few weeks ago which resolved the issue.
Also a couple of other commands they asked to run before we installed the wrapper:
Vacuum the individual tables first
#psql_client cpm postgres
Then run:
SELECT nspname || '.' || relname AS "relation", pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') AND C.relkind <> 'i' AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size(C.oid) DESC LIMIT 15;
Then vacuum the individual tables first, example:
vacuum (full, verbose) installstatus;
vacuum (full, verbose) abstractauditlogbase;
etc etc
From the smaller table over 100mb to the higher