my Debian server disk maxed out because of a large postgresql log file and while I have deleted it, it is still held by postgresql. When I restart postgresql I get an error as the disk is full and the software cannot start. This is the file listed using lsof +L1:
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NLINK NODE NAME testproxy 22712 postgres 2w REG 8,1 15309393920 0 1184540 /tmp/postgresql-9.4-main.log (deleted)
I've tried some commands suggested in other threads but it's not working. Can anyone suggest how to remove this file, bearing in mind restarting postgresql is not working?