Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Postgres crash? could not write to log file: No spaceleft on device
Date
Msg-id 12352.1372179540@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres crash? could not write to log file: No spaceleft on device  (bricklen <bricklen@gmail.com>)
List pgsql-bugs
Tree view 
bricklen <bricklen@gmail.com> writes:
> Assuming your stats_temp_directory is pg_stat_tmp, where is that directory
> located? Under $PGDATA?
> What is the path to $PGDATA?
> If your stats_temp_directory is located on a small partition, that could be
> a problem
> Where is your pg_xlog dir located?

The given error message is definitely complaining about being unable to
write a pg_xlog file --- stats or other temp files are not relevant.

            regards, tom lane

pgsql-bugs by date:

Previous
From: bricklen
Date:
Subject: Re: Postgres crash? could not write to log file: No spaceleft on device
Next
From: Jeff Davis
Date:
Subject: Re: Postgres crash? could not write to log file: No space left on device