Hi
Just for info: The “vacumeing” took about 12 h… The database is still the same size, but at least now, it IS cleaned up. Verified that with PHP-PGadmin…
It’s now doing a dump of that 30+ GB Database.
Next steps would be delete the DB and recreate with same user and perms, and restoring the dump.
As the dump is so big, I can’t use phppgadmin for that, it times out way too soon!
I’m doing the dump to a local folder, that should also speed up the restore using just CLI…
Backup dump finished:
Before cleanup, dump size = 16 GB (!)
After Cleanup, dump size 200 MB
We’re getting there!
(The database in PG still uses 16 GB as shown by NethServer Diskusage…)
Will keep you updated.
Andy