Search Postgresql Archives

Is it possible to recover the schema from the raw files?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

There was a corruption to the file system due to sudden shutdown of Windows
7.

The attempt to connect to one of the databases results in multiple errors,
like the following one:
ERROR:  invalid page in block 58 of relation base/161326/233745

Several raw files were completely lost (zeroed), thus utterly disabling the
functionality of this particural database.

The raw files were backed up separately outside of the original data folder
upon discovery of the issue.

I would like to ask whether it is possible to recover the database schema
from the raw files?
The data itself is less important in this case.

Thank you in advance for any insight into such a topic.

Kind regards,

Tomas



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux