11.7. Reclaiming PostgreSQL Space

Procedure

1. Stop all services, except for the postgresql service:

   # satellite-maintain service stop --exclude postgresql

   Copy to Clipboard Toggle word wrap

2. Switch to the postgres user and reclaim space on the database:

   # su - postgres -c 'vacuumdb --full --dbname=foreman'

   Copy to Clipboard Toggle word wrap

3. Start the other services when the vacuum completes:

   # satellite-maintain service start

   Copy to Clipboard Toggle word wrap