# PostgreSQL no space left on device **URL:** \ **Category:** Awards & Recognition\ **Created:** [October 30, 2024, 8:29am UTC](https://forums.percona.com/t/postgresql-no-space-left-on-device/34661 "2024-10-30T08:29:49Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![jruffer](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jruffer/32/16566_2.png) [@jruffer](https://forums.percona.com/u/jruffer)\ **Post date:** [October 30, 2024, 8:29am UTC](https://forums.percona.com/t/postgresql-no-space-left-on-device/34661/1 "2024-10-30T08:29:49Z")
System stuck in a loop trying to recover but can’t because no space. There are tables I could drop to give the space but I can connect to do that. ---
**Author:** ![Tibor\_Korocz\_Percona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tibor_korocz_percona/32/17251_2.png) [@Tibor\_Korocz\_Percona](https://forums.percona.com/u/Tibor_Korocz_Percona)\ **Post date:** [October 30, 2024, 10:04am UTC](https://forums.percona.com/t/postgresql-no-space-left-on-device/34661/2 "2024-10-30T10:04:42Z")
Hi, You can try drop some logs or not needed files from the filesystem which can give you some free space. Then you can: - clean up not needed tables - or increase the partition size - or move the database to another server with more space ---
**Author:** ![jruffer](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jruffer/32/16566_2.png) [@jruffer](https://forums.percona.com/u/jruffer)\ **Post date:** [October 30, 2024, 10:08am UTC](https://forums.percona.com/t/postgresql-no-space-left-on-device/34661/3 "2024-10-30T10:08:11Z")
I got lucky and identified a large table in a different database that wasn’t being used. I moved the datafiles and that gave enough space for recovery to complete. I am now running vacuum full which has freed up a lot of space.