Postgres Pro
Downloads
Home   >   mailing lists

Re: Corrupted index on 9.0.3 streaming hot standby - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Corrupted index on 9.0.3 streaming hot standby
Date
Msg-id 1298649207-sup-4689@alvh.no-ip.org
Whole thread Raw
In response to Corrupted index on 9.0.3 streaming hot standby  (Jakub Ouhrabka <kuba@comgate.cz>)
Responses Re: Corrupted index on 9.0.3 streaming hot standby  (Jakub Ouhrabka <jakub.ouhrabka@comgate.cz>)
List pgsql-bugs
Tree view 
Excerpts from Jakub Ouhrabka's message of vie feb 25 08:20:33 -0300 2011:

> For details about corrupted index see below. The table and index in
> question are mostly read-only (several queries per second) writes happen
> only few times a day.
>
> We've backed up whole cluster and recreated it.
>
> Shall we investigate it further? How? Is it possible that we make some
> mistake when doing initial backup which caused corruption? Is there a
> way to check other indexes?

Do you still have the WAL files?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Function trunc() behaves in unexpected manner with different data types
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #5899: Memory corruption when running psql