Re: Recovery inconsistencies, standby much larger than primary - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recovery inconsistencies, standby much larger than primary
Date
Msg-id 14854.1391183226@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recovery inconsistencies, standby much larger than primary  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Greg Stark <stark@mit.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



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Recovery inconsistencies, standby much larger than primary
Next
From: Robert Haas
Date:
Subject: Re: Add force option to dropdb