Search Postgresql Archives

Re: hardware failure - data recovery

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

 



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

On 10/18/06 23:52, Rick Gigger wrote:
> Rick Gigger wrote:
>> Ron Johnson wrote:
>>> -----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?
>>
>> Errors about a bunch of duplicate inodes, missing inodes, etc.  Should
>> I do it again and get some of the exact text for you?
> 
> Also this is an example of the type of errors that were being logged
> before it died:
> 
> LOG:  checkpoint record is at 26/41570488
> LOG:  redo record is at 26/41570488; undo record is at 0/0; shutdown TRUE

What does Google say about these error messages and your fs?

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

iD8DBQFFNwhNS9HxQb37XmcRAksiAJ4zWuLJKcOaAR5PI5QSgZt3NhAQEgCgplJn
p4Xfy5+I/K6uYD+MOg+e6Nc=
=nhTB
-----END PGP SIGNATURE-----


[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