Re: Help on copy function

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> frederic(dot)germaneau(at)bull(dot)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