On Fri, 23 Dec 2005 13:42:13 -0500, Michael Adler wrote: > On Fri, Dec 23, 2005 at 11:36:54AM -0500, Tom Lane wrote: >> Michael Adler <adler@xxxxxxxxx> writes: >> > I'm investigating a problem that happened last night and I would >> > appreciate any recommendations. The logs indicate that the disks were >> > full, but I truly doubt that since we only use about 14GB out of the >> > available 65GB. >> >> > I found entries like this in the logs: >> >> > ERROR: could not write block 2354 of temporary file: No space left on device >> > HINT: Perhaps out of disk space? >> > .... >> > ERROR: could not extend relation "parent_table": No space left on device >> > HINT: Check free disk space. >> > .... >> > LOG: could not close temporary statistics file "/var/lib/postgres/data/global/pgstat.tmp.1464": No space left on device >> >> > According to the logs, the problem went away after a reboot. I wonder >> > if the kernel or the RAID device got confused and postgres was simply >> > echoing what it was told. We run a couple hundred postgres servers and >> > we have not seen this before (except when the disks truly were full). > I really appreciate any guidance you could offer. > Are there any errors about running out of shared memory? I have seen the "No space left on device" error for that on FreeBSD before.
