From: | "Christopher A(dot) Goodfellow" <cgoodfellow(at)tealuxe(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'Michael Fuhr'" <mike(at)fuhr(dot)org>, "'Pgsql-Novice \(E-mail\)'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Invalid Page Header |
Date: | 2006-03-09 19:37:54 |
Message-ID: | 000901c643b0$f6441580$060a640a@wks10 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thank You. I set zero_damaged_pages to on using the owner user for the
database and did a select count(). The response was fixing. After setting
zero_damaged_pages to off, I still received the Invalid Page Header error.
I then set zero back to on and did a vacuum on the table. This solved the
problem. I did loose one row of data but I expected that.
Thank You,
Christopher A. Goodfellow
Corporate Director
Tealuxe, Inc.
Phone: 508-520-7887
Fax: 508-528-8999
Tea For All
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
Sent: Thursday, March 09, 2006 2:20 PM
To: Christopher A. Goodfellow
Cc: 'Michael Fuhr'; 'Pgsql-Novice (E-mail)'
Subject: Re: [NOVICE] Invalid Page Header
"Christopher A. Goodfellow" <cgoodfellow(at)tealuxe(dot)com> writes:
> I have read quite a bit in the archives and it seems the best way is to
> zero_damaged_pages. I did a search for zero_damaged_pages. Is it as
simple
> as adding zero_damaged_pages to postgresql.conf and restarting the
> postmaster?
Since zero_damaged_pages is a pretty dangerous thing to have on, I
wouldn't recommend turning it on in postgresql.conf. Instead, turn it
on within a single session using SET, and then scan the tables that you
want to clean up (a VACUUM or SELECT COUNT(*) will do).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | David Gaudine | 2006-03-09 21:13:47 | Function to convert numeric string to number in version 8.0 |
Previous Message | Tom Lane | 2006-03-09 19:20:04 | Re: Invalid Page Header |