Re: Database recovery after fs crash - Mailing list pgsql-general

From Alvaro Herrera Munoz
Subject Re: Database recovery after fs crash
Date
Msg-id 20030826133109.GA14306@dcc.uchile.cl
Whole thread Raw
In response to Re: Database recovery after fs crash  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Database recovery after fs crash  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote:
> Wow. Take to pull out those backups...
>
> Hmm, presumably you don't have those. There are programs to read postgresql
> data files however they need to know the exact structure of the table before
> you can even start to decode them. I usually start by browsing files by hand
> to see if I can determine from any embedded text which table it was.

Hm, you fail to mention your own pgfsck tool.  I wonder why.  I have not
tried it myself, but sounds like it can be handy.

IIRC it should be in http://svana.org/kleptog somewhere.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"God is real, unless declared as int"

pgsql-general by date:

Previous
From: "Andrew L. Gould"
Date:
Subject: Re: Excel 97 Export to Postgres
Next
From: Ron Johnson
Date:
Subject: Re: Linux ready for high-volume databases?