Re: Filesystem crash - corupted database

On Wed, Sep 26, 2007 at 11:59:28AM +0200, Martin Bedná? wrote:
> Hi,
>
> It's possible to extract data directly from data files ?
> I have two tablespaces one for data and one for indexes.
> After filesystem crash I lost my /var/lib/postgresql/data folder :( All
> data is in /lost+found :(, I found folders with data and index tablespe
> that looks ok.
> It's possible to directly access these files and extract data as CSV for
> example ?
> Or it's possible "mount" these tablespaces to new database instance ?

In theory if you resurrect the schema exactly as it was, and then copy
the old files in place, you *may* be able to read them. However, you're
going to have trouble with non-existing XIDs. Yo umight be able to
recreate the XLOG/CLOGs but the whether it's going to be consistant is
anyones guess...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.