Search Postgresql Archives

Re: Invalid page header

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Invalid page header
From: Poul Møller Hansen <freebsd@xxxxxxxx>
Date: Tue, 03 Jul 2007 13:09:00 +0200
Cc: "Michael Harris (BR/EPA)" <michael.harris@xxxxxxxxxxxx>
In-reply-to: <E5F4C5A18CAB7A4DA23080DE9CE81586042A93A5@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
User-agent: Thunderbird 1.5.0.10 (Windows/20070221)

I had a similar problem and overcame it by temporarily setting zero_damaged_pages, then doing a full vacuum and re-index on the affected table.

Thanks, I suppose I need to reindex the table afterwards, or they canpoint to non existent data ?


Poul

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Invalid page header
  - From: Poul Møller Hansen
- Re: Invalid page header
  - From: Michael Harris (BR/EPA)

Prev by Date: Re: How-To: Aggregate data from multiple rows into a delimited list.
Next by Date: Re: Invalid page header
Previous by thread: Re: Invalid page header
Next by thread: Re: Invalid page header
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux