Postgres Pro
Downloads
Home   >   mailing lists

Re: Lost replication slots after pg_upgrade. - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: Lost replication slots after pg_upgrade.
Date
Msg-id 20220208080843.an4ljxpjwncz5wqi@jrouhaud
Whole thread Raw
In response to Re: Lost replication slots after pg_upgrade.  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Responses Re: Lost replication slots after pg_upgrade.  (John DeSoi <desoi@pgedit.com>)
List pgsql-admin
Tree view 
On Tue, Feb 08, 2022 at 01:18:39PM +0530, Nikhil Shetty wrote:
> 
> Thank you for the information. I wanted to understand why the replication
> slot is removed after or during upgrade?

Because pg_upgrade modifies your primary instance in such a way that a standby
can't simply keep replicating from it.

pgsql-admin by date:

Previous
From: Nikhil Shetty
Date:
Subject: Re: Lost replication slots after pg_upgrade.
Next
From: Victor Sudakov
Date:
Subject: Re: Lost replication slots after pg_upgrade.