Re: Help with logical replication: pg_replication_slots.active_pid is null???? - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Help with logical replication: pg_replication_slots.active_pid is null????
Date
Msg-id ZLZsmG1h0RONZQ+/@depesz.com
Whole thread Raw
In response to Help with logical replication: pg_replication_slots.active_pid is null????  (Chris Hoover <chrish@aweber.com>)
List pgsql-admin
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
upgradefrom 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




pgsql-admin by date:

Previous
From: srinivas oguri
Date:
Subject: Re: PostgreSQL 12 VS PostgreSQL 15
Next
From: M Sarwar
Date:
Subject: How to schedule long running SQL job