Re: [HACKERS] How to ignore system indexes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] How to ignore system indexes
Date
Msg-id 200001181808.NAA02731@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] How to ignore system indexes  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
> > Sure, but it is disabled in 6.5 because we changed the binary table
> > format from 6.4 to 6.5.  However, I have already recommended people use
> > it who have broken system indexes, and it worked.
> >
> 
> It seems pg_upgrade is too complicated to recover system indexes.
> In addtion,could pg_upgrade/pg_dump/vacuum etc ... work even when
> a critical system index is broken ?

Yes, pg_dumpall -s may not work with broken system indexes.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: FETCH syntax
Next
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] patches list