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.

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

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.

PostgreSQL no space left on device

Percona News Awards & Recognition

Tibor_Korocz_Percona October 30, 2024, 10:04am 2

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

Topic		Replies	Views
delete table space Percona Server for MySQL 5.6	1	719	July 22, 2018
/tmp No space left on device Percona Server for MySQL 5.7 percona	3	1531	October 12, 2020
Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows PostgreSQL closed-no-reply	0	546	October 3, 2023
MYSQL Down and Inability of Restarting because of database crash Percona Server for MySQL 8.0 percona	0	109	December 19, 2024
pt-online-schema-change reclaiming InnoDB space Percona Toolkit	1	772	June 29, 2019

PostgreSQL no space left on device

Related topics