| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
| Cc: | bossartn(at)amazon(dot)com, andres(at)anarazel(dot)de, masao(dot)fujii(at)oss(dot)nttdata(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org, mengjuan(dot)cmj(at)alibaba-inc(dot)com, Jakub(dot)Wartak(at)tomtom(dot)com |
| Subject: | Re: prevent immature WAL streaming |
| Date: | 2021-09-17 16:37:05 |
| Message-ID: | 202109171637.uhx5nnwef2yu@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
Added Matsumura-san to CC, because he was interested in this topic too
per the earlier thread.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
| Attachment | Content-Type | Size |
|---|---|---|
| v7-0001-Implement-FIRST_IS_ABORTED_CONTRECORD.patch | text/x-diff | 17.9 KB |
| v7-0002-test-code.patch | text/x-diff | 3.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2021-09-17 16:53:58 | Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert |
| Previous Message | Bossart, Nathan | 2021-09-17 16:31:44 | Re: Estimating HugePages Requirements? |