Skip site navigation (1) Skip section navigation (2)

Re: files under pg_clog directories are missing

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: dbhandary(at)iii(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: files under pg_clog directories are missing
Date: 2010-09-18 07:48:50
Message-ID: 4C946EE2.5020701@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)2ndQuadrant(dot)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


In response to

pgsql-admin by date

Next:From: Mark RostronDate: 2010-09-18 18:41:13
Subject: management of pg-schemas: pg_temp_n and pg_toast_n ?
Previous:From: Thomas KellererDate: 2010-09-18 06:38:51
Subject: Re: question about HA in PG 9.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group