| From: | Louis Voo <jlvoo(at)yahoo(dot)com> |
|---|---|
| To: | Postgres <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_dump error unexpected chunk number |
| Date: | 2011-10-28 09:10:24 |
| Message-ID: | 1319793024.5183.YahooMailNeo@web30401.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I think I got a big problem now, I'm not able to do pg_dump on one of my production database. When I do pg_dump it give me this error:
pg_dump: Error message from server: ERROR: unexpected chunk number 18390760 (expected 4) for toast value 92784 in pg_toast_88487
I believe this message mean that my database is corrupted.
I do file base + continues archive backup every day, there is no problem for that, until now I need to upgrade from 9.0.4 to 9.1.1, so I did a pg_dump and found that the database is corrupted.
Hope someone can help me, thanks
Regards
Louis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mailtolouis2020-postgres@yahoo.com | 2011-10-28 10:24:34 | PG_DUMP error : unexpected chunk number |
| Previous Message | Thomas Kellerer | 2011-10-28 08:52:15 | Re: "Named" column default expression |