Thread: Retrievig text information from damaged DataBase

Retrievig text information from damaged DataBase

From
veejar
Date:
Hello!

My PostgreSQL DB was damaged, some files were removed and now I have such loss:

global/pg_auth
global/pg_database
global/pgstat.stat

fast all files in folder "pg_clog"

pg_subtrans/527E

all files in folder "pg_xlog"

And some small files in folder of my database.

Is it possible corrent database structure files and start pgsql server
or retrieve text information from database?

Re: Retrievig text information from damaged DataBase

From
Alvaro Herrera
Date:
veejar escribió:

> Is it possible corrent database structure files and start pgsql server
> or retrieve text information from database?

Pretty unlikely.  You can try using pg_filedump to get at the raw data:
http://sources.redhat.com/rhdb

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.