Re: Corrupted index file after restoring WAL on warm spare server - Mailing list pgsql-general

From Michael Nolan
Subject Re: Corrupted index file after restoring WAL on warm spare server
Date
Msg-id 4abad0eb0705241534k52bae3c9sebfda89e279646f0@mail.gmail.com
Whole thread Raw
In response to Re: Corrupted index file after restoring WAL on warm spare server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 5/24/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

It sounds like you have a reproducible test case --- can you make it
available to someone else?

Not very easily, Tom.  The tarball files are around 35 GB (uncompressed) and I assume they'd only work on a fairly similar system anyway.

I assume shell level access would be needed. I may be able to set up a way to get to someone through the firewall, but there are some security issues I'd have to clear with our Executive Director, since there's quite a bit of confidential information in the database and elsewhere on the server. 

Is this something where I could call someone and have them walk me through checking things?

I tried the same thing on a 3rd server (similar hardware and same O/S), and the query is working correctly there.  I'm not sure what that tells me.
--
Mike Nolan

pgsql-general by date:

Previous
From: "A.M."
Date:
Subject: Re: why postgresql over other RDBMS
Next
From: "George Pavlov"
Date:
Subject: index vs. seq scan choice?