Re: hardware failure - data recovery

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: hardware failure - data recovery
Дата
Msg-id 4537139B.5080302@cox.net
обсуждение исходный текст
Ответ на Re: hardware failure - data recovery  (Rick Gigger <rick@alpinenetworking.com>)
Ответы Re: hardware failure - data recovery  (Rick Gigger <rick@alpinenetworking.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/19/06 00:46, Rick Gigger wrote:
> Ron Johnson wrote:
>>
>> On 10/18/06 23:52, Rick Gigger wrote:
>>> Rick Gigger wrote:
>>>> Ron Johnson wrote:
>>>>>
>>>>> On 10/18/06 19:57, Rick Gigger wrote:
[snip]
> Not much that is useful.  I think this is a little beyond that scope.  A
> hardware failure basically left the fs and the db in an inconsistent
> state.  There is one table in one database that has a bunch of data in
> it that I need to get out.  I'm guessing I'm going to need to find
> someone who understands the the internal structure of the files to go in
> and pull out whatever data is still in tact.

So, no backup tapes?

> I have been poking around and as far as I can tell, although one of the
> toast indexes is gone the actual table files appear to be in tact.  That
> is they are still in the file system.  I don't know if they are ok
> internally.
>
> I also get this error when trying to access the non-toasted data:
>
> ERROR:  could not access status of transaction 307904873
> DETAIL:  could not open file "pg_clog/0125": No such file or directory
>
> I'm guessing that this means that I may have get someone to pull out all
> versions of a given tuple because I have lost some of the visibility
> info.  This shouldn't matter as most likely very few tuples would have
> had more than one version when the system went down.
>
> I just hope that the relations are need are in tact and that there is
> someone out there who can help me get it out.

What kernel, version & 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)

iD8DBQFFNxObS9HxQb37XmcRAkaJAKCKqIN76cHjvCqMJN3JqO7LBJZWfQCff2AT
WZWfEy3dWyByN2Q06IAt1kg=
=xmv+
-----END PGP SIGNATURE-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Rick Gigger
Дата:
Сообщение: Re: hardware failure - data recovery
Следующее
От: Rick Gigger
Дата:
Сообщение: Re: hardware failure - data recovery