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)
Список
Дерево обсуждения
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 по дате отправления
От: Michael Paquier
Дата: