Re: Help on copy function

Tom Lane <tgl@sss.pgh.pa.us> writes:

> frederic.germaneau@bull.net writes:
>> And an error occurs :
>> psql:lineitem.loader.psql:1: ERROR:  could not extend relation
>> 24342131/24342133
>> /24342324: There is not enough space in the file system.
>> HINT:  Check free disk space.
>
>> but my fileSystem has something like 2Go free when copy fails!
>
> Maybe you are running the postmaster under a disk-space-usage limit?
> I'm not sure that there's a separate errno for "you can't have any
> more space" as opposed to "there isn't any more space".

It's also possible that PG is trying to create a new table file and
he's out of inodes...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863