Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 8D4C51DB6346 for ; Mon, 7 May 2012 09:03:46 -0300 (ADT) Received: from mailout-de.gmx.net ([213.165.64.22]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SRMfI-0006dI-WA for pgsql-admin@postgresql.org; Mon, 07 May 2012 12:03:45 +0000 Received: (qmail 21952 invoked by uid 0); 7 May 2012 12:03:31 -0000 Received: from 83.246.65.146 by www011.gmx.net with HTTP; Mon, 07 May 2012 14:03:31 +0200 (CEST) Content-Type: text/plain; charset="utf-8" Date: Mon, 07 May 2012 14:03:30 +0200 From: "Jan-Peter Seifert" Message-ID: <20120507120330.3010@gmx.net> MIME-Version: 1.0 Subject: SQLSTATE 53100 could not extend file / disk full To: pgsql-admin@postgresql.org X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1+HcO4sTquHgPL8HCxd1kpZwKv0Q3IdTEpP7Vrb7h xI4lUMkGbpuoKrN/Oe0Nsd29R7efJS0luh+w== Content-Transfer-Encoding: 8bit X-GMX-UID: Rd/Vb0lgeSEqZ0D1ZXQhvxB+IGRvb4AB X-Pg-Spam-Score: -0.0 (/) X-Archive-Number: 201205/31 X-Sequence-Number: 39520 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