Le lun. 11 févr. 2019 à 08:44, CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG <yann.convers@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> a écrit :
Hi,
vaccum full don't deliver free space from files not in database. Your files are in the same directory but postgres doesn't kows them.
You must restore database and rename it, if you need to keep same name.
you can delete files without link in pg_database but it's more dangerous if you make mistake.
I have doing that to time last month on database of 300 GB.
I think i have a bog between proxmox/postgres 9.6.11 and ubuntu 16.04 but i haven't found it
There's more chance that PostgreSQL crashed for whatever reason and it lost tracks of some files because of that. Did you experience crash with PostgreSQL? because it shouldn't forget files otherwise.
--
Guillaume.
