Home > mailing lists

Re: [GENERAL] londiste3: removing a node that does not exist - Mailing list pgsql-general

From	Victor Yegorov
Subject	Re: [GENERAL] londiste3: removing a node that does not exist
Date	June 22, 2017 19:03:19
Msg-id	CAGnEbojLOBguO0Dmj69LGmKZfaEp+jNZ+ToDsSgPMQah-1Wq-A@mail.gmail.com Whole thread Raw
In response to	[GENERAL] londiste3: removing a node that does not exist (Willy-Bas Loos <willybas@gmail.com>)
Responses	Re: [GENERAL] londiste3: removing a node that does not exist
List	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

From: Peter Eisentraut
Date: 22 June 2017, 18:43:34
Subject: Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

From: Арсен Арутюнян
Date: 22 June 2017, 19:12:42
Subject: [GENERAL] SPI_execute_plan and vardata