Re: [GENERAL] londiste3: removing a node that does not exist

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: [GENERAL] londiste3: removing a node that does not exist
Дата
Msg-id CAGnEbojLOBguO0Dmj69LGmKZfaEp+jNZ+ToDsSgPMQah-1Wq-A@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] londiste3: removing a node that does not exist  (Willy-Bas Loos <willybas@gmail.com>)
Ответы Re: [GENERAL] londiste3: removing a node that does not exist  (Willy-Bas Loos <willybas@gmail.com>)
Список pgsql-general
Дерево обсуждения
2017-06-22 18:21 GMT+03:00 Willy-Bas Loos <willybas@gmail.com>:
Does anyone know of a method to get rid of the bad node and the data that it is gathering?

I also do not know the correct way to achieve this.


But once I needed to rename one of the queues to follow the internal naming standard.
And I used the following queries on the provider node to prune _old_ queue:

SET search_path TO pgq_node;
DELETE FROM local_state WHERE queue_name='q-2rm';
DELETE FROM subscriber_info WHERE queue_name='q-2rm';
DELETE FROM node_info WHERE queue_name='q-2rm';
DELETE FROM node_location WHERE queue_name='q-2rm';

And restarted worker after that.


--
Victor Yegorov

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] pglogical vs. built-in logical replication in pg-10
Следующее
От: Арсен Арутюнян
Дата:
Сообщение: [GENERAL] SPI_execute_plan and vardata