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
pgsql-general by date
|Next:||From: firstname.lastname@example.org||Date: 2011-10-28 10:24:34|
|Subject: PG_DUMP error : unexpected chunk number|
|Previous:||From: Thomas Kellerer||Date: 2011-10-28 08:52:15|
|Subject: Re: "Named" column default expression|