Re: recovering a control file from a shutdown database.... - Mailing list pgsql-general

From Tom Lane
Subject Re: recovering a control file from a shutdown database....
Date
Msg-id 29318.999746140@sss.pgh.pa.us
Whole thread Raw
In response to recovering a control file from a shutdown database....  (Jerry Asher <jerry@theashergroup.com>)
List pgsql-general
Jerry Asher <jerry@theashergroup.com> writes:
> Can anything be done to recover the pg_control file?

I've already been talking to Jerry off-list, and I trust he's managed
to recover his data --- but for the archives, the answer to this is to
hack up contrib/pg_resetxlog to force whatever data you need into the
pg_control file.

It is an *extremely* good idea to back up your whole $PGDATA directory
tree (with tar or some such) before attempting such desperate measures,
so that you can undo any self-inflicted damage if you get it wrong...

            regards, tom lane

pgsql-general by date:

Previous
From: Tomas Berndtsson
Date:
Subject: connection failed in threaded application
Next
From: Bruce Momjian
Date:
Subject: Re: jdbc driver with BigDecimal patch