Re: hardware failure - data recovery

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/18/06 19:57, Rick Gigger wrote:
> To make a long story short lets just say that I had a bit of a hardware
> failure recently.
>
> If I got an error like this when trying to dump a db from the mangled
> data directory is it safe to say it's totally hosed or is there some
> chance of recovery?
>
> pg_dump: ERROR:  could not open relation 1663/18392/18400: No such file
> or directory
> pg_dump: SQL command to dump the contents of table "file" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR:  could not open relation
> 1663/18392/18400: No such file or directory
> pg_dump: The command was: COPY public.file (vfs_id, vfs_type, vfs_path,
> vfs_name, vfs_modified, vfs_owner, vfs_data) TO stdout;

What happens when you fsck the relevant partitions?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNtOdS9HxQb37XmcRAqswAJ0X6up02yGXkky6YBrVHIK3DXuO1ACgqbI/
//TGGkVOIe9o4sKzuUHyuXI=
=fZuZ
-----END PGP SIGNATURE-----