From: Greg Smith <greg@2ndquadrant.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: dbhandary@iii.com
Cc: pgsql-admin@postgresql.org
Subject: Re: files under pg_clog directories are missing
Date: Sat, 18 Sep 2010 03:48:50 -0400
Message-ID: <4C946EE2.5020701@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTik2hQz6yx186=kz4=4u+ZgKHWmDdW974QnFFP2P@mail.gmail.com>
References: <4C940889.3000505@iii.com>
<4C9432DA.4000609@2ndquadrant.com>
<AANLkTik2hQz6yx186=kz4=4u+ZgKHWmDdW974QnFFP2P@mail.gmail.com>
Scott Marlowe wrote:
> As a followup to all this, the OP also needs to figure out why a
> crashed server could cause so much corruption. This is usually the
> result of hardware lying about fsync status, i.e. consumer grade
> hardware pressed into service as a server.
>
See http://www.postgresql.org/docs/9.0/static/wal-reliability.html for
more information. Nothing there has changed in 9.0 relative to the
version being run here, but the docs for that version got a big upgrade
over the earlier ones.
Bad memory is always a potential source for issues in this area too.
Mostly if you don't know why the crash happened, either. If you know
for sure how it crashed, but only then found corruption, Scott's right
that it's more likely to be a lying disk drive instead.
--
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, scott.marlowe@gmail.com, dbhandary@iii.com
Subject: Re: files under pg_clog directories are missing
In-Reply-To: <4C946EE2.5020701@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