Re: lost replication slots after pg_upgrade

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: lost replication slots after pg_upgrade
Date: 2020-10-13 16:37:14
Message-ID: CAFj8pRALhOYQrg=3weP6ZU27qRYZ3ML06K4AceNg5nT1NK0F9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

út 13. 10. 2020 v 18:33 odesílatel Bruce Momjian <bruce(at)momjian(dot)us> napsal:

> On Tue, Oct 13, 2020 at 06:20:41PM +0200, Pavel Stehule wrote:
> > Hi
> >
> > One customer reports issue related to pg_upgrade.
> >
> > I found a thread https://www.postgresql-archive.org/
> >
> Upgrade-and-re-synchronization-with-logical-replication-pglogical-and-PG-10-td6001990.html
> >
> > But I didn't find documentation of this limitation?
>
> So, what is the question? Peter Eisentraut is right that WAL is not
> preserved, so replication slots are not preserved. We do have
> pg_upgrade instructions for upgrading binary replication, but I assume
> people recreate the slots.
>

I cannot find related documentation.

> --
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EnterpriseDB https://enterprisedb.com
>
> The usefulness of a cup is in its emptiness, Bruce Lee
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-10-13 16:50:48 Getting rid of intermittent PPC64 buildfarm failures
Previous Message Bruce Momjian 2020-10-13 16:33:49 Re: lost replication slots after pg_upgrade