Re: 12.3 replicas falling over during WAL redo

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Ben Chobot <bench(at)silentmedia(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: 12.3 replicas falling over during WAL redo
Date: 2020-08-03 22:04:21
Message-ID: CAH2-Wzk3Dp9PFaQjQ3broCbGT=UB2Deau=kPY5_gqYjqvGwb=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 3, 2020 at 2:35 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> You can use pageinspect's page_header() function to obtain the page's
> LSN. You can use dd to obtain the page from the file,
>
> dd if=16605/16613/60529051 bs=8192 count=1 seek=6501 of=/tmp/page.6501

Ben might find this approach to dumping out a single page image
easier, since it doesn't involve relfilenodes or filesystem files:

https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#contrib.2Fpageinspect_page_dump

--
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2020-08-03 22:10:49 Re: 12.3 replicas falling over during WAL redo
Previous Message Alvaro Herrera 2020-08-03 21:34:54 Re: 12.3 replicas falling over during WAL redo