Skip site navigation (1) Skip section navigation (2)

pg_dump error unexpected chunk number

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 (view raw or flat)
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

pgsql-general by date

Next:From: mailtolouis2020-postgres@yahoo.comDate: 2011-10-28 10:24:34
Subject: PG_DUMP error : unexpected chunk number
Previous:From: Thomas KellererDate: 2011-10-28 08:52:15
Subject: Re: "Named" column default expression

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group