Re: londiste3: removing a node that does not exist

[Victor Yegorov <vyegorov@xxxxxxxxx>]

2017-06-22 18:21 GMT+03:00 Willy-Bas Loos <willybas@xxxxxxxxx>:

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