Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsOrM-0008T9-T0 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2013 02:24:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TsOrL-0004Rw-Ur for pgsql-admin@arkaria.postgresql.org; Tue, 08 Jan 2013 02:24:11 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsOrK-0004Ro-Uu for pgsql-admin@postgresql.org; Tue, 08 Jan 2013 02:24:11 +0000 Received: from outmail149082.authsmtp.co.uk ([62.13.149.82]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsOrG-00068p-U1 for pgsql-admin@postgresql.org; Tue, 08 Jan 2013 02:24:10 +0000 Received: from mail-c232.authsmtp.com (mail-c232.authsmtp.com [62.13.128.232]) by punt14.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r082O4xp068451; Tue, 8 Jan 2013 02:24:04 GMT Received: from ayaki.localdomain (124-169-61-64.dyn.iinet.net.au [124.169.61.64]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id r082NvUZ076405 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Tue, 8 Jan 2013 02:24:00 GMT Message-ID: <50EB833C.4060206@2ndQuadrant.com> Date: Tue, 08 Jan 2013 10:23:56 +0800 From: Craig Ringer Organization: 2nd Quadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: Benjamin Krajmalnik CC: pgsql-admin@postgresql.org Subject: Re: Possible database corruption References: In-Reply-To: X-Enigmail-Version: 1.4.6 Content-Type: multipart/alternative; boundary="------------080504060108080504040401" X-Server-Quench: 7760ddd4-593a-11e2-b10b-0025903375e2 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZeVg0b BQteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaA1bZ1hf HGQLWldEUF97W2d/ awgfbAdZfEtIVhts UVZPRk1QEQdtHh1P RB4WUGc0Em9Gf3h0 ZUMsX3NZW0E0ckF7 QhoAQWkbYG5jOX0e URVaalFVcFFXfh9H b1l/V3AKZDAFKBg1 TUcAFhwUHBNqYBxS WRoMJ1YfCUoCAjc2 TgsPVT4oB1cYXzky KBpO X-Authentic-SMTP: 61633235383639.1019:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 124.169.61.64/2525 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------080504060108080504040401 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 01/08/2013 05:22 AM, Benjamin Krajmalnik wrote: > > I have a situation where pg_xlog started growing until it filled up > the disk drive. > This should not ever cause corruption. If it has, there's a bug at work. A crash is reasonable (albeit undesirable; it'd be better to just report errors on connections) - but database corruption is not. Before doing ANYTHING else, read http://wiki.postgresql.org/wiki/Corruption and act on it. How big is the DB? What file system is it on? PostgreSQL 9.0.[what?] ? Host OS? Disk subsystem? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --------------080504060108080504040401 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 01/08/2013 05:22 AM, Benjamin Krajmalnik wrote:

I have a situation where pg_xlog started growing until it filled up the disk drive.

This should not ever cause corruption. If it has, there's a bug at work.

A crash is reasonable (albeit undesirable; it'd be better to just report errors on connections) - but database corruption is not.

Before doing ANYTHING else, read http://wiki.postgresql.org/wiki/Corruption and act on it.

How big is the DB?

What file system is it on?

PostgreSQL 9.0.[what?] ?

Host OS?

Disk subsystem?


-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
--------------080504060108080504040401--