From: Greg Smith <greg@2ndquadrant.com>
To: dbhandary@iii.com
Cc: pgsql-admin@postgresql.org
Subject: Re: files under pg_clog directories are missing
Date: Mon, 20 Sep 2010 14:15:39 -0400
Message-ID: <4C97A4CB.6050604@2ndquadrant.com> (raw)
In-Reply-To: <4C9785B6.6030506@iii.com>
References: <4C940889.3000505@iii.com>
<4C9432DA.4000609@2ndquadrant.com>
<4C9785B6.6030506@iii.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndquadrant.com, dbhandary@iii.com
Subject: Re: files under pg_clog directories are missing
In-Reply-To: <4C97A4CB.6050604@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox