Date: Tue, 18 Jul 2023 12:42:32 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Chris Hoover <chrish@aweber.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Help with logical replication: pg_replication_slots.active_pid
 is null????
Message-ID: <ZLZsmG1h0RONZQ+/@depesz.com>
Reply-To: depesz@depesz.com
References: <3DF8573D-9E47-4770-94A1-C0B873BD1D7C@aweber.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <3DF8573D-9E47-4770-94A1-C0B873BD1D7C@aweber.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZLZsmG1h0RONZQ%2B/%40depesz.com>
Precedence: bulk

On Sun, Jul 16, 2023 at 08:30:59PM -0400, Chris Hoover wrote:
> Hey Everyone,
> 
> Need some help with logical replication.  I’m trying to move my mail 2.5TB database to a new postgres server and upgrade from 14-15 at the same time.  I’m running into some strange issues.
> 
> 1. my pg_replication_slots are filling up with entries that have no active pid.  I can’t figure out what is going on here.

Please consider reading
https://www.depesz.com/2023/06/04/a-tale-about-incomplete-upgrade-from-postgresql-12-to-14/

Your problem is one of problems I encountered, and the post contains
information how to work around it.

Best regards,

depesz