Re: prevent immature WAL streaming - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: prevent immature WAL streaming
Date
Msg-id EFBE9A36-8842-4991-A626-58F6A41386E8@amazon.com
Whole thread Raw
In response to Re: prevent immature WAL streaming  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: prevent immature WAL streaming
List pgsql-hackers
On 9/17/21, 9:37 AM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
> OK, this version is much more palatable, because here we verify that the
> OVERWRITE_CONTRECORD we replay matches the record that was lost.  Also,
> I wrote a test script that creates such a broken record (by the simple
> expedient of deleting the WAL file containing the second half while the
> server is down); we then create a standby and we can observe that it
> replays the sequence correctly.
>
> If you have some time to try your reproducers with this new proposed
> fix, I would appreciate it.

I haven't had a chance to look at the patch yet, but it appears to fix
things with my original reproduction steps for the archive_status
stuff [0].

Nathan

[0] https://postgr.es/m/CBDDFA01-6E40-46BB-9F98-9340F4379505%40amazon.com


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Next
From: Alvaro Herrera
Date:
Subject: Re: prevent immature WAL streaming