Обсуждение: PostgreSQL 7.1.3 recovery tool "pg_check" no longer works

Hi everyone,

Has anyone taken a look at the pg_check data recovery tool with
PostgreSQL 7.1.x or 7.2bx?

http://www.arcamax.com/pg_check/

It was known to work with PostgreSQL 7.0.x, but I can't get it to
compile with PostgreSQL 7.1.3.

It seems we now have no last-ditch-effort recovery tools available.

:-(

Has anyone played with this and gotten it working?  (And can hopefully
share their changes with us)

Or, does anyone know of any other last-ditch-recovery-effort tools?

We kind of need at least one.  You know, just in case.

:-)

Regards and best wishes,

Justin Clift

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

Justin Clift wrote:
> Hi everyone,
>
> Has anyone taken a look at the pg_check data recovery tool with
> PostgreSQL 7.1.x or 7.2bx?
>
> http://www.arcamax.com/pg_check/
>
> It was known to work with PostgreSQL 7.0.x, but I can't get it to
> compile with PostgreSQL 7.1.3.
>
> It seems we now have no last-ditch-effort recovery tools available.
>
> :-(
>
> Has anyone played with this and gotten it working?  (And can hopefully
> share their changes with us)
>
> Or, does anyone know of any other last-ditch-recovery-effort tools?
>
> We kind of need at least one.  You know, just in case.

Well, my new pg_upgrade can be used as a recovery tool, and has been
used for this purpose in the past.  It requires that you be able to
access the system tables of the old database.  It may help you.   It is
in CVS under /contrib.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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, Pennsylvania 19026