Postgres Pro
Downloads
Home   >   mailing lists

pg_dump error unexpected chunk number - Mailing list pgsql-general

From Louis Voo
Subject pg_dump error unexpected chunk number
Date
Msg-id 1319793024.5183.YahooMailNeo@web30401.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: whiplash
Date:
Subject: Client-site "lo_export"
Next
From: kucoj
Date:
Subject: Re: Unable to write inside TEMP environment variable path