Re: Postgres crash? could not write to log file: No spaceleft on device

From: bricklen <bricklen(at)gmail(dot)com>
To: Yuri Levinsky <yuril(at)celltick(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres crash? could not write to log file: No spaceleft on device
Date: 2013-06-25 16:48:24
Message-ID: CAGrpgQ_gQhKVYR_1iidqeq+76akSK=NN52cVj5hFRYaSnDfVfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jun 25, 2013 at 9:43 AM, Yuri Levinsky <yuril(at)celltick(dot)com> wrote:

> I inspected my config file and didn't see any destination that isn't
> /data/postgres. Have I perform any specific setting to limit it into
> /data/postgres?

Execute from psql:

show stats_temp_directory
stats_temp_directory
----------------------
pg_stat_tmp

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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-06-25 16:59:00 Re: Postgres crash? could not write to log file: No spaceleft on device
Previous Message Yuri Levinsky 2013-06-25 16:43:22 Re: Postgres crash? could not write to log file: No spaceleft on device