Hi all,
Our postgres instance on one of our production machines has recently been
returning errors of the form "DatabaseError: invalid page header in block 1
of relation base/16384/76623" from normal queries. I've been reading that
these are often linked to hardware errors, but I would like to bet
ny general bits of information regarding the potential causes of these
types of issues would be much appreciated.
thanks,
Cory
On Fri, Dec 26, 2014 at 6:55 AM, Sameer Kumar
wrote:
> On 23 Dec 2014 12:05, "Cory Zue" wrote:
> >
> > Hi all,
> >
> > Our pos
PM, chiru r wrote:
> Hi Cory,
>
> After recovering table turn off *zero_damaged_pages *parameter.
>
>
> On Fri, Dec 26, 2014 at 9:13 PM, Cory Zue wrote:
>
>> Hi all,
>>
>> Thanks for the responses. Chiru, I'm looking into your suggestion.
>>
>
(nevermind - it looks like the zero_damaged_pages setting only took for the
duration of the session)
On Fri, Dec 26, 2014 at 5:15 PM, Cory Zue wrote:
> Hi Chiru,
>
> I am trying to pg_dump the database to have a snapshot of the current
> state. I've turned on 'zero_damaged
a hardware issue on my machine? Is there anything
else that could be causing this to come back?
thanks,
Cory
On Fri, Dec 26, 2014 at 5:15 PM, Cory Zue wrote:
> Hi Chiru,
>
> I am trying to pg_dump the database to have a snapshot of the current
> state. I've turned on 'ze
