On Tue, Sep 29, 2009 at 07:51:19PM -0700, roctaiwan wrote:

> I just found out a error in /data/serverlog that it said "could not write to
> log file: No space left on device"

I _think_ that's the Postgres transaction log (the Write Ahead Log or
WAL).  If you're out of space where that's stored, I would expect you
to be in pretty serious trouble.  Also, note that just because your
current GUI seems to think you have 6 G does not mean that there's 6 G
available to the Postgres user.

Anyway, again, this is a Posrgres basic question, and I think you need
to head over to pgsql-novice for some help.

A


-- 
Andrew Sullivan
ajs at crankycanuck.ca