Re: Order of removing logical replication

Поиск
Список
Период
Сортировка
От Jayson Hreczuck
Тема Re: Order of removing logical replication
Дата
Msg-id CAHg7=h6X+AuLv3-PrvoUDL_j_oWra8bnxY6ZTZsy6iSj3wM4VA@mail.gmail.com
обсуждение исходный текст
Ответ на Order of removing logical replication  (Yambu <hyambu@gmail.com>)
Список pgsql-admin
That's the order but it's logical replication, and wouldn't interfere with your master even if you ran it out of order.  

I have 12 databases doing logical shipping to our subscription server and occasionally it breaks but the master is never affected.  When you restart the subs there will be some I/O due to data shipping however.

Since we are talking about logical rep: What I would LOVE is schema change support for the logical replication!  

On Fri, Apr 23, 2021, 9:23 AM Yambu <hyambu@gmail.com> wrote:
Hello

May i know in which order i have to stop logical replication without causing issues on postgres

1. drop subscription on slave
2. drop slot on master

regards

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

Предыдущее
От: Yambu
Дата:
Сообщение: Order of removing logical replication
Следующее
От: Jorge Silva
Дата:
Сообщение: xPath in a database with LATIN1 encoding