Yaroslav Tykhiy wrote:
> By the way, `chkdsk' in Windows or `fsck' in Unix can, in a way, be a
> _source_ of file loss if the file metadata got damaged badly, e.g., by a
> system crash, and the file node has to be cleared. So I've always been
> curious if there is a way to retrieve surviving records from a
> PostgreSQL database damaged by file loss. Do you know any? (Of course,
> the only true solution is to have been making backups beforehand, but...)
The Ubuntu Linux site has this page on data recovery (also applicable to
other Linux flavors):
https://help.ubuntu.com/community/DataRecovery
I assume that a database file, because of its structure, is harder to
recover after it becomes corrupt than, say, an XML file. But any port
in a storm, right?
>
> Thanks!
>
> Yar
>