Re: corrupted item pointer:???
| От | hubert depesz lubaczewski |
|---|---|
| Тема | Re: corrupted item pointer:??? |
| Дата | |
| Msg-id | 9e4684ce0604140156j591abdfcm699a65bebfa013b8@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: corrupted item pointer:??? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: corrupted item pointer:???
|
| Список | pgsql-general |
On 4/13/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
the problematic table spans over 3 files (18026 18026.1 and 18026.2).
i made pg_filedump _FILE_ > ~/_FILE_.dump
it went fine
grep -i error ~/*.dump also didn't show anything.
the dumps are quite large:
pgdba@lab02:~$ ls -l *.dump
-rw-r--r-- 1 pgdba pgdba 154631630 2006-04-14 18:03 18026.1.dump
-rw-r--r-- 1 pgdba pgdba 108808017 2006-04-14 18:03 18026.2.dump
-rw-r--r-- 1 pgdba pgdba 161625849 2006-04-14 18:01 18026.dump
what else can i look in it for?
best regards
hubert
pg_filedump will complain about a bad item pointer (looks like the
message will be something about "Error: Item contents extend beyond block")
the problematic table spans over 3 files (18026 18026.1 and 18026.2).
i made pg_filedump _FILE_ > ~/_FILE_.dump
it went fine
grep -i error ~/*.dump also didn't show anything.
the dumps are quite large:
pgdba@lab02:~$ ls -l *.dump
-rw-r--r-- 1 pgdba pgdba 154631630 2006-04-14 18:03 18026.1.dump
-rw-r--r-- 1 pgdba pgdba 108808017 2006-04-14 18:03 18026.2.dump
-rw-r--r-- 1 pgdba pgdba 161625849 2006-04-14 18:01 18026.dump
what else can i look in it for?
best regards
hubert
В списке pgsql-general по дате отправления: