Re: londiste3: removing a node that does not exist

2017-06-22 18:21 GMT+03:00 Willy-Bas Loos <willybas(at)gmail(dot)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