Postgres Pro
Downloads
Home   >   mailing lists

Re: recover in single-user backend fails - Mailing list pgsql-general

From Gregory Stark
Subject Re: recover in single-user backend fails
Date
Msg-id 87fxocz3mu.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: recover in single-user backend fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: recover in single-user backend fails  ("Wouter Sergeyssels" <Wouter@nucleus.be>)
List pgsql-general
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> writes:

> The only recovery strategy that I can think of in 8.1 is to blow away
> your WAL with pg_resetxlog, let the database come up in a damaged
> condition, and then try to extract data from it.

Would it work if he rebuilt 8.1 with a "return;" as the first line of
gist_redo() in gistxlog.c and when recovery (hopefully) completes immediately
drop any gist indexes?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL
Next
From: "Uwe C. Schroeder"
Date:
Subject: A challenge for the SQL gurus out there...