Re: pg_basebackup --create-slot-if-not-exists?

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_basebackup --create-slot-if-not-exists?
Дата
Msg-id YyuwYkdSGVVkf90R@paquier.xyz
обсуждение исходный текст
Ответ на Re: pg_basebackup --create-slot-if-not-exists?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: pg_basebackup --create-slot-if-not-exists?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Sep 21, 2022 at 05:34:20PM -0700, David G. Johnston wrote:
> What’s the use case for automating pg_basebackup with a named replication
> slot created by the pg_basebackup command?  Why can you not leverage a
> temporary replication slot (i.e., omit —slot). ISTM the create option is
> basically obsolete now.

+1.

Perhaps the ask would ease some monitoring around pg_replication_slots
with a fixed slot name?  One thing that could come into play is the
possibility to enforce the use of a temporary slot with a name given
by -S as pg_basebackup makes it permanent in this case, still the
temporary slot name being pg_basebackup_${PID} makes the slot
searchable with a pattern.
--
Michael

Вложения

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_basebackup --create-slot-if-not-exists?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: make additional use of optimized linear search routines