No space left on disk (PostgreSQL)
0
votes
1
answer
4169
views
I was trying to write a 55GB SQL file to my database. It used to crash each time. I removed logs and did some cleaning to get the server running, but the transaction never used to complete. Latter, I emptied all the tables I was writing into (I had a backup), but even after that, when I tried writing the SQL file, it gave me this error after a series of successful inserts - Could not write to file "pg_subtrans/14C6" at offset 106496: No space left on device.
Is there a way out of this? Are there logs related to PGSQL that I should still clean? I've read that moving the pg_xlog might just help? Should I try this?
Any help will be appreciated.
Thanks!
Output of
df -h
reformatted from comment for readability.
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_zarkin-lv_root 574G 540G 4.3G 100% /
/dev/sda1 194M 35M 150M 19% /boot
tmpfs 5.9G 928K 5.9G 1% /dev/shm
/dev/mapper/smeidc0-smeisky0 7.2T 5.2T 2.0T 73% /smeidc/sky0
/dev/md0 7.2T 6.5T 400G 95% /smeidc/backup
Asked by Pushpak Raj Gautam
(1 rep)
Jul 5, 2017, 10:35 PM
Last activity: Jan 11, 2024, 05:51 AM
Last activity: Jan 11, 2024, 05:51 AM