Skip site navigation (1) Skip section navigation (2)

Re: Data corruption after SAN snapshot

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Terry Schmitt <tschmitt(at)schmittworks(dot)com>
Cc: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Data corruption after SAN snapshot
Date: 2012-08-08 01:39:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

* Terry Schmitt (tschmitt(at)schmittworks(dot)com) wrote:
> So far, executing pg_dumpall
> seems to be fairly reliable for finding the corrupt objects after my
> initial data load, but unfortunately much of the corruption has been with
> indexes which pgdump will not expose.

Shouldn't be too hard to write a script that'll do a query against each
table using an ORDER BY that matches each index, at least for 'simple'
indexes, which'll typically cause an in-order index traversal.

Just a thought.



In response to


pgsql-admin by date

Next:From: Michael O'DonnellDate: 2012-08-08 02:07:25
Subject: PostgreSQL 9.0 authentication against LDAP/AD
Previous:From: Stephen FrostDate: 2012-08-08 01:34:25
Subject: Re: Data corruption after SAN snapshot

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group