Re: Recovery inconsistencies, standby much larger than primary

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Recovery inconsistencies, standby much larger than primary
Date: 2014-01-31 15:47:06
Message-ID: 14854.1391183226@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <stark(at)mit(dot)edu> writes:
> Sorry guys. I transposed two numbers when looking up the relation.
> "data_pk" wasn't the right index.

> =# select (page_header(get_raw_page('index_data_id', 'main', 3020854))).* ;
> lsn | tli | flags | lower | upper | special | pagesize |
> version | prune_xid
> --------------+-----+-------+-------+-------+---------+----------+---------+-----------
> CF0/2DD67BB8 | 5 | 0 | 792 | 5104 | 8176 | 8192 |
> 4 | 0
> (1 row)

Clearly not the right page --- the LSN isn't what we saw in the hexdump.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-01-31 15:47:09 Re: Add force option to dropdb
Previous Message Greg Stark 2014-01-31 15:43:09 Re: Recovery inconsistencies, standby much larger than primary