11.7. Reclaiming PostgreSQL Space
The PostgreSQL database can use a large amount of disk space especially in heavily loaded deployments. Use this procedure to reclaim some of this disk space on Satellite.
Procedure
Stop all services, except for the
postgresqlservice:# satellite-maintain service stop --exclude postgresql
Switch to the
postgresuser and reclaim space on the database:# su - postgres -c 'vacuumdb --full --dbname=foreman'
Start the other services when the vacuum completes:
# satellite-maintain service start