Re: pg_basebackup --create-slot-if-not-exists? - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_basebackup --create-slot-if-not-exists?
Date
Msg-id YyuwYkdSGVVkf90R@paquier.xyz
Whole thread Raw
In response to Re: pg_basebackup --create-slot-if-not-exists?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pg_basebackup --create-slot-if-not-exists?
List 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

Attachment

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_basebackup --create-slot-if-not-exists?
Next
From: Michael Paquier
Date:
Subject: Re: make additional use of optimized linear search routines