Re: Database corruption. - Mailing list pgsql-general

From Michael Guerin
Subject Re: Database corruption.
Date
Msg-id 45CA9222.5050009@rentec.com
Whole thread Raw
In response to Re: Database corruption.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Database corruption.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Hmm, that makes it sound like a plain old data-corruption problem, ie,
> trashed xmin or xmax in some tuple header.  Can you do a "select
> count(*)" from this table without getting the error?
>
>
no,  select count(*) fails around 25 millions rows.
>>> PostgreSQL 8.1RC1 on x86_64-unknown-linux-gnu, compiled by GCC gcc
>>> (GCC) 4.0.1
>>>
>
> [ raised eyebrow... ]  You're keeping important data in an RC version
> that you've not updated for more than a year?  Your faith in Postgres'
> code quality is touching, but I'd counsel getting onto a more recent
> release.
>
>

>             regards, tom lane
>


pgsql-general by date:

Previous
From: rob_spellberg
Date:
Subject: Re: a request for the 8.1.7 and 8.2.2 tarballs and the good reasons why
Next
From: "jws"
Date:
Subject: 'greatest' function?