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@xxxxxxxxxxxxxxx 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
