Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres crash? could not write to log file: No space left on device - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgres crash? could not write to log file: No space left on device
Date
Msg-id 8881.1372168007@sss.pgh.pa.us
Whole thread Raw
In response to Postgres crash? could not write to log file: No space left on device  ("Yuri Levinsky" <yuril@celltick.com>)
Responses Re: Postgres crash? could not write to log file: No spaceleft on device
Re: Postgres crash? could not write to log file: No space left on device
List pgsql-bugs
Tree view 
"Yuri Levinsky" <yuril@celltick.com> writes:
> I have the following issue on Sun Solaris 10. PostgreSQL version is
> 9.2.3. The wall logging is minimal and no archiving. The DB restarted
> several time, the box is up for last 23 days. The PostgreSQL
> installation and files under /data/postgres that is half empty. Is it
> some other destination that might cause the problem? Can I log the space
> consumption and directory name where the problem is happening by some
> debug level or trace setting?

> PANIC:  could not write to log file 81, segment 125 at offset 13959168,
> length 1392640: No space left on device

That's definitely telling you it got ENOSPC from a write in
$PGDATA/pg_xlog.  Maybe you have a user-specific space quota affecting
the postgres account?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Yuri Levinsky"
Date:
Subject: Postgres crash? could not write to log file: No space left on device
Next
From: "Yuri Levinsky"
Date:
Subject: Re: Postgres crash? could not write to log file: No spaceleft on device