Hey Guys, Thanks for your input. Meanwhile we have recovered from a backup.
Lesson of all this, upgrade asap to postgres 8.2? Thanks, WS. -----Original Message----- From: Greg Stark [mailto:[EMAIL PROTECTED] On Behalf Of Gregory Stark Sent: zondag 7 september 2008 11:50 To: Tom Lane Cc: Wouter Sergeyssels; pgsql-general@postgresql.org Subject: Re: recover in single-user backend fails Tom Lane <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
