Re: Help with logical replication: pg_replication_slots.active_pid is null????

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Help with logical replication: pg_replication_slots.active_pid is null????
Дата
Msg-id ZLZsmG1h0RONZQ+/@depesz.com
обсуждение исходный текст
Ответ на Help with logical replication: pg_replication_slots.active_pid is null????  (Chris Hoover <chrish@aweber.com>)
Список 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 по дате отправления:

Предыдущее
От: srinivas oguri
Дата:
Сообщение: Re: PostgreSQL 12 VS PostgreSQL 15
Следующее
От: M Sarwar
Дата:
Сообщение: How to schedule long running SQL job