Df command not updating
EDIT: You might want to either vacuum and reindex the database, or dump and restore.In BSD a directory entry is simply one of many references to the underlying file data (called an inode).Currently, I have lost approximately 200G from hard drive, and I need to reclaim that - but don't know what to do to reclaim it - any ideas? I am running Ubuntu 10.0.4 LTS postgresql 8.4 Update 4 /usr/src/linux-headers-2.6.32-38-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-41-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-36-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-30-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-35-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-31-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-27-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-28-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-40-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-34-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-37-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-33-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-39-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-29-generic/include/config/mtdram/total 4 /usr/src/linux-headers-2.6.32-32-generic/include/config/mtdram/total 187426036 total Filesystem Inodes IUsed IFree IUse% Mounted on /dev/sda1 29M 1.8M 27M 7% / none 491K 776 490K 1% /dev none 492K 6 492K 1% /dev/shm none 492K 76 492K 1% /var/run none 492K 2 492K 1% /var/lock none 492K 1 492K 1% /lib/init/rw /dev/sdb1 30M 3.0K 30M 1% /mydata /dev/sdc1 0 0 0 - /media/Cruzer to judge where the space went.
Also, refer to this post about Flushing the Postgresql cache.
Most of the time files are deleted manually but processes using those files are keep them open and hence space is not reclaimed.
[email protected] # lsof L1 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NLINK NODE NAME tuned 777 root 7u REG 202,2 4096 0 8827610 /tmp/ffi JEo5nz (deleted) [email protected] # lsof | grep -i deleted tuned 777 root 7u REG 202,2 4096 0 8827610 /tmp/ffi JEo5nz (deleted) kill process.
This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant.]]
Sometimes, application users are moving/deleting large log files and still wont be able to reclaim space on mount point.In this troubleshooting guide, I will walk you through steps which will help you to reclaim space on disk after deleting files.Here we will learn how to remove deleted open files in Linux.I don't understand this, as I use rm * (in the data directory), and in the cases where I use Nautilus, I empty the Trash bin as well.Similarly, I notice that when I import the data into the (postgresql) database, and then delete the data from the tables using , the size consumed in the postgresql data directory does not go down either.