public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Haas <[email protected]>
To: Amit Kapila <[email protected]>
Cc: Euler Taveira <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected]
Cc: Euler Taveira <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Subject: Re: State of pg_createsubscriber
Date: Wed, 22 May 2024 10:32:32 -0400
Message-ID: <CA+TgmoYZ4gRD4uf7Uy3uoyaqZMYwdDX-N0g810QYpD83Lkt7OA@mail.gmail.com> (raw)
In-Reply-To: <CAA4eK1J22UEfrqx222h5j9DQ7nxGrTbAa_BC+=mQXdXs-RCsew@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<CAA4eK1J22UEfrqx222h5j9DQ7nxGrTbAa_BC+=mQXdXs-RCsew@mail.gmail.com>

On Mon, May 20, 2024 at 2:42 AM Amit Kapila <[email protected]> wrote:
> Just to summarize, apart from BF failures for which we had some
> discussion, I could recall the following open points:
>
> 1. After promotion, the pre-existing replication objects should be
> removed (either optionally or always), otherwise, it can lead to a new
> subscriber not being able to restart or getting some unwarranted data.
> [1][2].
>
> 2. Retaining synced slots on new subscribers can lead to unnecessary
> WAL retention and dead rows [3].
>
> 3. We need to consider whether some of the messages displayed in
> --dry-run mode are useful or not [4].

Amit, thanks for summarzing your understanding of the situation. Tom,
is this list complete, to your knowledge? The original thread is quite
complex and it's hard to pick out what the open items actually are.
:-(

I would like to see this open item broken up into multiple open items,
one per issue.

Link [4] goes to a message that doesn't seem to relate to --dry-run.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: State of pg_createsubscriber
  In-Reply-To: <CA+TgmoYZ4gRD4uf7Uy3uoyaqZMYwdDX-N0g810QYpD83Lkt7OA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox