Re: Completely broken replica after PANIC: WAL contains references to invalid pages

On 2013-03-29 14:19:59 -0700, Sergey Konoplev wrote:
> On Fri, Mar 29, 2013 at 1:52 PM, anarazel@anarazel.de
> <andres@anarazel.de> wrote:
> > I think I See whats going on. Do you still have the datadir available=
? If so, could you send the pg_controldata output?
>=20
> I have already rebuilt the replica, however below is the output if it i=
s useful:

I have to admit, I find it a bit confusing that so many people report a
bug and then immediately destroy all evidence of the bug. Just seems to
a happen a bit too frequently.

> pg_control version number:            922
> Catalog version number:               201204301
> Database system identifier:           5858109675396804534
> Database cluster state:               in archive recovery
> pg_control last modified:             =D0=A1=D0=B1=D1=82 30 =D0=9C=D0=B0=
=D1=80 2013 00:21:11
> Latest checkpoint location:           258B/BDBBE748
> Prior checkpoint location:            258B/86DABCB8
> Latest checkpoint's REDO location:    258B/8B78BED0
> Latest checkpoint's TimeLineID:       2
> Latest checkpoint's full_page_writes: on
> Latest checkpoint's NextXID:          0/423386899
> Latest checkpoint's NextOID:          2758636912
> Latest checkpoint's NextMultiXactId:  103920
> Latest checkpoint's NextMultiOffset:  431309
> Latest checkpoint's oldestXID:        225634745
> Latest checkpoint's oldestXID's DB:   16436
> Latest checkpoint's oldestActiveXID:  421766298
> Time of latest checkpoint:            =D0=9F=D1=82=D0=BD 29 =D0=9C=D0=B0=
=D1=80 2013 22:33:01

Thats not a pg_controldata output from the broken replica though, or is
it? I guess its from a new standby?

Andres
Greetings,

Andres Freund

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