Re: Londiste 3 pgq events_1_1 table huge - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Londiste 3 pgq events_1_1 table huge
Date
Msg-id 573F1130.1010605@griensu.com
Whole thread Raw
In response to Re: Londiste 3 pgq events_1_1 table huge  (Leonardo M. Ramé <l.rame@griensu.com>)
List pgsql-general
El 20/05/16 a las 10:19, Leonardo M. Ramé escribió:
> El 19/05/16 a las 12:39, Saiful Muhajir escribió:
>> This has happened to us where we have dead or unmanaged consumer. Turns
>> out londiste is keeping the event even if the consumer is unreachable.
>> This is to ensure that the consumer gets what it should.
>>
>> To clean this up, delete the unused/dead consumer, with qadmin or
>> manually if necessary. The table won't be deleted immediately though. We
>> have to restart pgqd and workers and wait for two days.
>>
>
>
> Thanks Rene and Saiful, I found two unused consumers, but after
> "unregister consumer ...." those aren't deleted, what can I do to remove
> them?.
>

Sorry, I successfully deleted them by using:

     unregister consumer CONSUMER_NAME from QUEUE_NAME

The 2nd param QUEUE_NAME is a *must*.

Now I'm waiting for the events deletion...

Regards,

--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877


pgsql-general by date:

Previous
From: Leonardo M. Ramé
Date:
Subject: Re: Londiste 3 pgq events_1_1 table huge
Next
From: John McKown
Date:
Subject: Re: PostgreSql Doubts