-----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-----
