Should you ever run out of disk space, here is one possible way to correct the problem.

Now, how do we clean up? Well, we make ourselves a little breathing room, then let PostgreSQL clean it up.

First thing is to use tune2fs to give us the reserved space back from the filesystem:

tune2fs -m 0 /dev/sda3

then start the postgresql service. It should replay the necessary xlogs, then trim them down to no more than 81.

after that's done, use tune2fs to set the reserve space back to 5%

tune2fs -m 5 /dev/sda3

so you can get yourself out of this jam again if it happens.

Browser not supported