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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
