RE: Stronger safeguard for archive recovery not to miss data

Поиск
Список
Период
Сортировка
От osumi.takamichi@fujitsu.com
Тема RE: Stronger safeguard for archive recovery not to miss data
Дата
Msg-id OSBPR01MB48881C0B250FF1E4B35C761AEDF90@OSBPR01MB4888.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Stronger safeguard for archive recovery not to miss data  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
Hello, Horiguchi-San


On Thursday, Nov 26, 2020 4:29 PM Kyotaro Horiguchi <horikyota.ntt@gmail.com>
> At Thu, 26 Nov 2020 07:18:39 +0000, "osumi.takamichi@fujitsu.com"
> <osumi.takamichi@fujitsu.com> wrote in
> > In order to test this fix, what I did is
> > 1 - get a base backup during wal_level is replica
> > 2 - stop the server and change the wal_level from replica to minimal
> > 3 - restart the server(to generate XLOG_PARAMETER_CHANGE)
> > 4 - stop the server and make the wal_level back to replica
> > 5 - start the server again
> > 6 - execute archive recoveries in both cases
> >     (1) by editing the postgresql.conf and
> >     touching recovery.signal in the base backup from 1th step
> >     (2) by making a replica with standby.signal
> > * During wal_level is replica, I enabled archive_mode in this test.
> >
> Perhaps we need the TAP test that conducts the above steps.
It really makes sense that it's better to show the procedures
about how to reproduce the flow.
Thanks for your advice.

Best,
    Takamichi Osumi



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: walsender bug: stuck during shutdown