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