Nearly full db disk, cannot vacuum any more

Support
1

Problem:
The data disk of the postresql db on the foreman server is nearly full. I cannot vacuum and regain space
Is it possible to use pg_dump to backup the foreman database, delete the database, and restore it in order to solve this problem?

Expected outcome:
have enought space on the /var/lib/psql disk again

Foreman and Proxy versions:
1.24.2-1

Foreman and Proxy plugin versions:
1.24.2-1

Distribution and version:
rhel 7

2

Yes.

You can also add a new disk, copy the data over, and mount it in the right place. Should be quicker than dump/restore.