| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Doug McNaught <doug(at)mcnaught(dot)org> |
| Cc: | frederic(dot)germaneau(at)bull(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help on copy function |
| Date: | 2004-10-06 22:20:09 |
| Message-ID: | 811.1097101209@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Doug McNaught <doug(at)mcnaught(dot)org> writes:
>>> 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.
>>
>> 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...
Good thought, although I think that this particular error message would
only come out from a seek/write failure and not from an open failure.
In any case it's some sort of externally imposed resource limit ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-10-06 22:26:05 | Re: postgres.h location? |
| Previous Message | Doug McNaught | 2004-10-06 22:14:18 | Re: Help on copy function |