Re: recover in single-user backend fails

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Wouter Sergeyssels" <Wouter(at)nucleus(dot)be>, pgsql-general(at)postgresql(dot)org
Subject: Re: recover in single-user backend fails
Date: 2008-09-07 09:50:17
Message-ID: 87fxocz3mu.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2008-09-07 09:53:15 A challenge for the SQL gurus out there...
Previous Message Tom Lane 2008-09-07 04:47:06 Re: 64-bit Compile Failure on Solaris 10 with OpenSSL