hardware failure - data recovery

From: Rick Gigger <rick(at)alpinenetworking(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: hardware failure - data recovery
Date: 2006-10-19 00:57:40
Message-ID: DDB90018-67B9-44AD-B634-924D0296E3BF@alpinenetworking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Thanks,

Rick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2006-10-19 01:23:41 Re: hardware failure - data recovery
Previous Message Taras Kopets 2006-10-19 00:10:43 Re: Link error: LNK2019: unresolved external symbol _pg_detoast_datum