Search Postgresql Archives

Re: Londiste 3 pgq events_1_1 table huge

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux