I have a postgres database running on my application, and the postgres partition is 100% full. Upon checking the files in pgdata directory is see below files occupying lot of space.
smsstoregt1 ins /postgres/pgdata/base/16384> du -skh * | grep -i M 589M 16400 244M 16405
Please can anyone suggest how to cleanup the space and if we can move the files 16400 and 16405 to another path or delete them, or if we can purge any data from postgres database from DB login.
Below is my postgres partition
/dev/mapper/mpath0p1 939M 900M 0 100% /postgres