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

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: pg_basebackup --create-slot-if-not-exists?
Дата
Msg-id
YyuwYkdSGVVkf90R@paquier.xyz
Ответ на
Список
Дерево обсуждения
pg_basebackup --create-slot-if-not-exists? Ashwin Agrawal <ashwinstar@gmail.com>
Re: pg_basebackup --create-slot-if-not-exists? "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_basebackup --create-slot-if-not-exists? Ashwin Agrawal <ashwinstar@gmail.com>
Re: pg_basebackup --create-slot-if-not-exists? Michael Paquier <michael@paquier.xyz>
Re: pg_basebackup --create-slot-if-not-exists? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_basebackup --create-slot-if-not-exists? Michael Banck <mbanck@gmx.net>
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
Дата:
От: Michael Paquier
Дата:
FAQ