From: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
---|---|
To: | cyberdemn(at)gmail(dot)com |
Cc: | bungina(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_rewind WAL segments deletion pitfall |
Date: | 2022-08-30 07:51:31 |
Message-ID: | 20220830.165131.1873011317661150194.horikyota.ntt@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
At Tue, 30 Aug 2022 08:49:27 +0200, Alexander Kukushkin <cyberdemn(at)gmail(dot)com> wrote in
> No, we are complaining exactly about WAL segments from the old timeline
> that are removed by pg_rewind.
> Those segments haven't been archived by the old primary and the new primary
> already recycled them.
Yeah, sorry for my thick skull but I finally got your point.
And as I said in a mail I sent just before, the patch looks too
complex. How about just comparing WAL file name aginst the last
common checkpoint's tli and lsn? We can tell filemap.c about the last
checkpoint and decide_file_action can compare the file name with it.
It is sufficient to preserve WAL files if tli matches and the segment
number of the WAL file is equal to or later than the checkpoint
location.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Kukushkin | 2022-08-30 08:03:07 | Re: pg_rewind WAL segments deletion pitfall |
Previous Message | Etsuro Fujita | 2022-08-30 07:50:46 | Re: foreign join error "variable not found in subplan target list" |
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro Horiguchi | 2022-08-30 08:02:53 | Re: Fix japanese translation of log messages |
Previous Message | Benoit Lobréau | 2022-08-30 07:49:20 | Re: archive modules |