Re: files under pg_clog directories are missing - Mailing list pgsql-admin

From Greg Smith
Subject Re: files under pg_clog directories are missing
Date
Msg-id 4C97A4CB.6050604@2ndquadrant.com
Whole thread Raw
In response to Re: files under pg_clog directories are missing  (Dinesh Bhandary <dbhandary@iii.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: files under pg_clog directories are missing
Next
From: fida aljounaidi
Date:
Subject: [Postgresql 8.4.2] problem restoring data