pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: pgsql-admin@postgresql.org
Subject: SQLSTATE 53100 could not extend file / disk full
Date: Mon, 07 May 2012 14:03:30 +0200
Message-ID: <20120507120330.3010@gmx.net> (raw)

Hello,

I wonder whether extra measures are necessary to recover from a disk full error besides freeing enough disk space?

It seems that there are enough security measures:
http://archives.postgresql.org/message-id/CAHHcrepQNCN3HoXSWAOtsj3HJKp5NoepB2ky3dFgVA4JCXh-Qw@mail.g...

Is it no problem if the WAL is within the same disk space and can't be written as well?

I didn't see anything in the FAQ:
http://wiki.postgresql.org/wiki/FAQ

Should you free enough disk space, do a checkpoint, restart the server and check the server log?

Thank you very much,

Peter







-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de



view thread (2+ messages)  latest in thread

Message-ID: <20120507120330.3010@gmx.net>
Permalink:  ../20120507120330.3010@gmx.net/
Also on:    postgresql.org/message-id/20120507120330.3010@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Jan-Peter.Seifert@gmx.de
  Subject: Re: SQLSTATE 53100 could not extend file / disk full
  In-Reply-To: <20120507120330.3010@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox