Re: pg_upgrade and publication/subscription problem

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: pg_upgrade and publication/subscription problem
Дата
Msg-id CAB-JLwYkPjD=C+RNtxd8RTSQXLJHFTO3HefhxKB46LsrvmPV_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade and publication/subscription problem  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: pg_upgrade and publication/subscription problem  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
The reason is after an upgrade, there won't be any data in
pg_subscription_rel, and only when you tried to refresh it is trying
to sync again which leads to the "duplicate key value ..." problem you
are seeing.

So, is pg_upgrade populating pg_subscription and not pg_subscription_rel ? It is doing 50% of his job ?

Don't you want to eventually upgrade the publisher node as well? You
can refer to blog [1] for the detailed steps.

It is possible but I don´t think changing publisher will solve anything, will ?

Yes, the way you are doing I think it is bound to happen. There is
some discussion about why this is happening in email [2]. AFAIK, it is
not documented and if so, I think it will be a good idea to document

And my problem remains the same, how to solve it ? All records on pg_subscription_rel are initialize with srsubstate null. How can I replay only updates since yesterday. This replication is a auditing database, so I cannot loose all things happened since that pg_upgrade. [1] points me how to upgrade but if I did the wrong way, how to solve that ?

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

Предыдущее
От: Virender Singla
Дата:
Сообщение: Re: TOAST - why separate visibility map
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: Non-decimal integer literals