From: hubert depesz lubaczewski <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????
Date: Tue, 18 Jul 2023 12:42:32 +0200
Message-ID: <ZLZsmG1h0RONZQ+/@depesz.com> (raw)
In-Reply-To: <3DF8573D-9E47-4770-94A1-C0B873BD1D7C@aweber.com>
References: <3DF8573D-9E47-4770-94A1-C0B873BD1D7C@aweber.com>
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
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: pgsql-admin@postgresql.org
Cc: depesz@depesz.com, chrish@aweber.com, pgsql-admin@lists.postgresql.org
Subject: Re: Help with logical replication: pg_replication_slots.active_pid is null????
In-Reply-To: <ZLZsmG1h0RONZQ+/@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox