Re: Database recovery after fs crash

From: Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>
To: J(dot)Henning(at)t-online(dot)de, pgsql-general(at)postgresql(dot)org
Subject: Re: Database recovery after fs crash
Date: 2003-08-26 13:31:09
Message-ID: 20030826133109.GA14306@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"God is real, unless declared as int"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JM 2003-08-26 13:42:52 Best tweak for fast results.. ?
Previous Message Ron Johnson 2003-08-26 13:12:29 Re: Linux ready for high-volume databases?