| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data corruption zero a file - help!! |
| Date: | 2006-03-09 02:57:49 |
| Message-ID: | 20060309025749.GA59440@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 09, 2006 at 12:29:17PM +1100, Noel Faux wrote:
> Thanks for all your help Michael, we wish to do a vacuum and dump before
> the upgrade to 8.02.
8.0.7 and 8.1.3 are the latest versions in their respective branches;
those are the versions to run to get the latest bug fixes.
> Do you believe this data corruption is a postgres issue of an
> OS / hardware issue?
Beats me; it could be any or all of them. Certain filesystem and
hardware configurations are more prone to data corruption than
others, especially in the event of a system crash, so those are
among the usual suspects. One reason to look at the data in the
bad block is to see what's there: if you see data that obviously
came from outside the database then that would tend to exonerate
PostgreSQL.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-03-09 03:26:29 | Re: Data corruption zero a file - help!! |
| Previous Message | Noel Faux | 2006-03-09 01:37:52 | Re: Data corruption zero a file - help!! |