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: 20120808013931.GO1267@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-admin
Terry,

* 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.

	Thanks,

		Stephen

In response to

Responses

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-2014 The PostgreSQL Global Development Group