Re: Recovery inconsistencies, standby much larger than primary

On 2014-01-31 15:21:35 +0000, Greg Stark wrote:
> On Fri, Jan 31, 2014 at 3:19 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> >> =# select get_raw_page('data_pkey', 'main', 11073632) ;
> >> ERROR: block number 11073632 is out of range for relation "data_pkey"
> >
> > Isn't the page 3634978?
>
> The page in the record is.

It'd be interesting to look at the referenced page using bt_page_items().

> But the page on disk is in the 54th segment at offset 1F0C0000

It's interesting that the smgr gets this wrong then (as also evidenced
by the fact that relation_size does as well). Could you please do a ls
-l path/to/relfilenode*?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services