Re: Trying to understand a failed upgrade in AWS RDS

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Trying to understand a failed upgrade in AWS RDS
Дата
Msg-id CAOBaU_ZoT18AFxLo24iAtHQr3xF9whix++EOPpMW5KMP6fWSsA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trying to understand a failed upgrade in AWS RDS  (Mike Lissner <mlissner@michaeljaylissner.com>)
Ответы Re: Trying to understand a failed upgrade in AWS RDS
Список pgsql-general
On Sat, 20 May 2023, 05:56 Mike Lissner, <mlissner@michaeljaylissner.com> wrote:

I'm still trying to understand what went wrong though. Putting a finer point on my question: Does pg_upgrade mess up disabled subscriptions?

yes, whether they're disabled or not. As far as I know it's impossible to reliably pg_upgrade a node that has subscriptions and eventually resume logical replication. 

It's possible to make it work with some efforts in some basic configurations and / or if no changes happen on the publications, but it's up to you trying to find out if your specific scenario can work as it's not documented. It's also impossible to check whether some incompatible events happened on any of the publisher nodes so you have to make sure that you have total control and knowledge of all the activity that happens on the publisher nodes during the upgrade. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Tiffany Thang
Дата:
Сообщение: Profiling a function call
Следующее
От: Pedro Gonçalves
Дата:
Сообщение: DBeaver postgres localhost access