Skip site navigation (1) Skip section navigation (2)

Re: BUG #5947: Error while running query

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Raman Sharma <rsharma(at)10kinfo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5947: Error while running query
Date: 2011-03-25 11:46:20
Message-ID: AANLkTik1MBQGkfOJrunGbK5Fu-Y_KBX3o0N=u-ahsLa0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, Mar 25, 2011 at 9:47 AM, Raman Sharma <rsharma(at)10kinfo(dot)com> wrote:
> ERROR:  could not extend relation "test_table": No space left on device
> HINT:  Check free disk space.
>>
> But i have 27 GB space in my disk where it loaded and running query

Have you checked df -i ?

Also, this may seem like a silly question but years of experience
motivate it.... are you sure your data is on the filesystem you're
checking?

Also, 7.4 is *ancient*. You really really want to be using something
more recent. I doubt it's relevant to why you're running out of space
though.



-- 
greg

In response to

pgsql-bugs by date

Next:From: Mihail PopovDate: 2011-03-25 13:35:08
Subject: BUG #5949: ODBC driver. Binding Arrays of Parameters
Previous:From: yuriy.tereschukDate: 2011-03-25 10:58:27
Subject: BUG #5948: JDBC wrond insert of timestamp data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group