Re: [HACKERS] Creating backup history files for backups taken from standbys

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: [HACKERS] Creating backup history files for backups taken from standbys
Дата
Msg-id CAD21AoBNuo2OXRr0sAZFY8s5XBTjH-sop6QxuCPYvSE-2hp1Pg@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Creating backup history files for backups taken from standbys  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: [HACKERS] Creating backup history files for backups taken from standbys  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On Thu, Aug 10, 2017 at 3:56 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> Hi all,
>
> In the recent thread related to a bug in pg_stop_backup when waiting
> for WAL segments to be archived, it has been mentioned that it would
> be nice to get backup history files generated as well on standbys:
> https://www.postgresql.org/message-id/CA+Tgmobh3=quCzugFP5yA3-z5uzz=YKZ7arnoApJoPN7=0H8TQ@mail.gmail.com
>
> Backup history files are not essential to backups, but they are for
> debugging purposes, and it has bugged me hard that we should have a
> consistent behavior in this area, particularly because with
> archive_mode = always they can be archived by a standby.
>
> The previous thread has ended with 52f8a59d, which addressed the
> original problem but discarded the backup history file generation
> during recovery. Attached is a patch to fix this inconsistency, parked
> in next CF. I am not arguing for this change as a bug fix, but as an
> improvement for PG11.
>
> Thoughts?

Thank you for the patch. Regarding to creating the backup history file
on stanbys, is there any difference from the patch posted on earlier
thread?

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix inadequacies in recentlyadded wait events
Следующее
От: Rushabh Lathia
Дата:
Сообщение: Re: [HACKERS] reload-through-the-top-parent switch the partition table