Date: Tue, 22 Mar 2022 12:26:46 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: vignesh C <vignesh21@gmail.com>
Cc: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: Logical replication stops dropping used initial-sync replication
 slots
Message-ID: <20220322112646.GA14817@depesz.com>
Reply-To: depesz@depesz.com
References: <20220317142426.GA727@depesz.com>
 <20220318122758.GA25022@depesz.com>
 <CALDaNm0+k0M6SDSVEsRWoS8VkwYtTz3WAQcjPWRheKu2-ym-pQ@mail.gmail.com>
 <20220321144341.GA27089@depesz.com>
 <CALDaNm1S-DtphU51d3orNknjyNQEjAOL90jXAxkis_n4rtS=eA@mail.gmail.com>
 <20220322034847.GA15952@depesz.com>
 <CALDaNm2Za2KU-R07dXKGYjM1UF1SZtbBR1BycxHC-dzjc0OSnA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CALDaNm2Za2KU-R07dXKGYjM1UF1SZtbBR1BycxHC-dzjc0OSnA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20220322112646.GA14817%40depesz.com>
Precedence: bulk

On Tue, Mar 22, 2022 at 12:32:41PM +0530, vignesh C wrote:
> > That wouldn't do me any good. The server I'm trying to upgrade now is
> > test bench to make sure that I can upgrade using logical replication *at
> > all*.
> > Once I will have verified that I can, I have couple hundred servers to
> > upgrade, that will have concurrent access all the time.
> Is it possible to get  a reproducible test or a script for this problem?

Well, given that we're talking about 38GB database with 60k tables
i find that unlikely.

But I'll try if I can figure out a way to replicate the problem with
something that is shareable.

depesz