Skip site navigation (1) Skip section navigation (2)

SQLSTATE 53100 could not extend file / disk full

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: SQLSTATE 53100 could not extend file / disk full
Date: 2012-05-07 12:03:30
Message-ID: 20120507120330.3010@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
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.gmail.com

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

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-05-07 17:09:49
Subject: Re: SQLSTATE 53100 could not extend file / disk full
Previous:From: Craig JamesDate: 2012-05-04 16:57:43
Subject: C/C++ Linker Problem in Postgres extension functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group