Re: recover in single-user backend fails

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: recover in single-user backend fails
Дата
Msg-id 87fxocz3mu.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: recover in single-user backend fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: recover in single-user backend fails  ("Wouter Sergeyssels" <Wouter@nucleus.be>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 64-bit Compile Failure on Solaris 10 with OpenSSL
Следующее
От: "Uwe C. Schroeder"
Дата:
Сообщение: A challenge for the SQL gurus out there...