2017-06-22 18:21 GMT+03:00 Willy-Bas Loos <willy...@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
