Re: How to reset WAL enveironment - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: How to reset WAL enveironment
Date
Msg-id 3A2DA4BE.F2255ED@tpf.co.jp
Whole thread Raw
In response to RE: How to reset WAL enveironment  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
Mikheev, Vadim wrote:
> 
> > I see now the following message and couldn't start
> > postmaster.
> >
> > FATAL 2:  btree_insert_redo: uninitialized page
> >
> > Is it a bug ?
> 
> Seems so. btree_insert_redo shouldn't see uninitialized pages
> (only newroot and split ops add pages to index and they should
> be redone before insert op).
> Can you post/ftp me tgz of data dir?
> Or start up postmaster with --wal_debug=1 and send me
> output.
>

Probably this is caused by my trial (local) change
and generated an illegal log output.
However it seems to mean that WAL isn't always
redo-able. In my case the index is probably a
system index unfortunately. Is there a way to
avoid invoking recovery process at startup ?

Regards.

Hiroshi Inoue


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: How to reset WAL enveironment
Next
From: Thomas Lockhart
Date:
Subject: Re: problem with timestamps ?