Re: Help on copy function - Mailing list pgsql-general

From Doug McNaught
Subject Re: Help on copy function
Date
Msg-id 873c0rlcjp.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: Help on copy function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Help on copy function
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres.h location?
Next
From: Tom Lane
Date:
Subject: Re: Help on copy function