| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Chester Kustarz <chester(at)arbor(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Corrupted Data? |
| Date: | 2004-09-15 18:45:10 |
| Message-ID: | 20040915184510.GE4607@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 15, 2004 at 02:37:13PM -0400, Matthew T. O'Connor wrote:
> However, I then ran into a new problem while trying to dump another
> database. Now I get this:
>
> dbmail=# SELECT * from messageblks ;
> ERROR: invalid page header in block 85646 of relation "pg_toast_2353340"
>
> Any ideas on this new issue?
IMO this is FUBAR ... try enabling zero_damaged_pages. Beware that data
on damaged pages will be lost.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-09-15 18:47:39 | Re: disk performance benchmarks |
| Previous Message | David Fetter | 2004-09-15 18:44:30 | Re: division by zero issue |