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