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

Re: DB corruption.

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <lukasz(dot)brodziak(at)gmail(dot)com>,<jesper(at)krogh(dot)cc>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: DB corruption.
Date: 2011-10-09 12:31:40
Message-ID: 4E914DDC0200002500041C5C@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Lukasz Brodziak  wrote:
 
> I would go with cluster on the relation with invalid page header

Or, if you don't have the free disk space or the time for that, you
could drop and recreate the index.  You could even do that with no
down time or long blocks by using CREATE INDEX CONCURRENTLY.
 
-Kevin

pgsql-admin by date

Next:From: Ray StellDate: 2011-10-09 13:17:11
Subject: Re: DB corruption.
Previous:From: Lukasz BrodziakDate: 2011-10-09 08:49:28
Subject: Re: DB corruption.

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