Re: Listen/notify across clusters

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Listen/notify across clusters
Дата
Msg-id CAFNqd5X0UpzVbczX3S0+KVYUCe-58Mx-uL=wYX3mky7AL+T=pA@mail.gmail.com
обсуждение исходный текст
Ответ на Listen/notify across clusters  (Greg Jaskiewicz <gryzman@mac.com>)
Список pgsql-hackers
Shouldn't be possible.

The act of requesting to LISTEN requires doing a sort of update to the database.  In elder versions, it put tuple(s) into pg_catalog.pg_listener, and that's Right Well Disallowed on a WAL-based replica.

I would think that if you're keen on building an "event detection substrate," particularly one that's supposed to cross clusters, then you should consider using something actually attuned to that, such as a message queueing system, whether an AMQP implementation such as RabbitMQ, or a message bus like Spread.  If you do that, then you can do this in much broader cross-cluster ways for unrelated Postgres clusters.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Jaskiewicz
Дата:
Сообщение: Listen/notify across clusters
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [PERFORM] In progress INSERT wrecks plans on table