Message-ID: <4C97A4CB.6050604@2ndquadrant.com>
Date: Mon, 20 Sep 2010 14:15:39 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: dbhandary@iii.com
CC: pgsql-admin@postgresql.org
Subject: Re: files under pg_clog directories are missing
References: <4C940889.3000505@iii.com> <4C9432DA.4000609@2ndquadrant.com>
	<4C9785B6.6030506@iii.com>
In-Reply-To: <4C9785B6.6030506@iii.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dinesh Bhandary wrote:
> As for the nature of the corruption I still do know know what kind of 
> hardware problems led to this; it happened at one of our clients site 
> and we are still waiting to find out what caused it.  One piece of 
> info we got was postgres data directory turned into read only partition.

That can happen when a major disk-level problem occurs; system remounts 
as read-only because it doesn't think it can safely write to it 
anymore.  I'd check into the system kernel logs as soon as possible, to 
try and find a disk error that kicked the whole thing off.

-- 
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support  www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance"    Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book