Re: Strange database corruption with PostgreSQL 7.4.x o - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: Strange database corruption with PostgreSQL 7.4.x o
Date
Msg-id 20060920142046.GH30944@batory.org.pl
Whole thread Raw
In response to Re: Strange database corruption with PostgreSQL 7.4.x o  (Matthias.Pitzl@izb.de)
List pgsql-general
On Wed, 20 Sep 2006, Matthias.Pitzl@izb.de wrote:

> Any ideas how i could check the hardware?

1. memtest86 or memtest86+ at least 8 hours

2. CPU Burn-in
http://users.bigpond.net.au/cpuburn/ at least 8 hours

3. badblocks -s -v -t random /dev/sd%
WARNING: this will destroy your data!

4. smartctl -a /dev/sd%
Does not have to work. Sometimes needs some hacking to make it work.

Dave "KernelSlacker" Jones wrote a very good article about hardware
problems:
http://people.redhat.com/davej/hardware-problems.txt

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

pgsql-general by date:

Previous
From: Matthias.Pitzl@izb.de
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x o
Next
From: Tom Lane
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge