Postgres Pro
Downloads
Home   >   mailing lists

Re: 12.3 replicas falling over during WAL redo - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: 12.3 replicas falling over during WAL redo
Date
Msg-id CAH2-Wzk3Dp9PFaQjQ3broCbGT=UB2Deau=kPY5_gqYjqvGwb=g@mail.gmail.com
Whole thread Raw
In response to Re: 12.3 replicas falling over during WAL redo  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: 12.3 replicas falling over during WAL redo  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Tree view 
On Mon, Aug 3, 2020 at 2:35 PM Alvaro Herrera <alvherre@2ndquadrant.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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 12.3 replicas falling over during WAL redo
Next
From: Ben Chobot
Date:
Subject: Re: 12.3 replicas falling over during WAL redo