Re: Listen/notify across clusters - Mailing list pgsql-hackers

From Christopher Browne
Subject Re: Listen/notify across clusters
Date
Msg-id CAFNqd5X0UpzVbczX3S0+KVYUCe-58Mx-uL=wYX3mky7AL+T=pA@mail.gmail.com
Whole thread Raw
In response to Listen/notify across clusters  (Greg Jaskiewicz <gryzman@mac.com>)
List 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 by date:

Previous
From: Greg Jaskiewicz
Date:
Subject: Listen/notify across clusters
Next
From: Josh Berkus
Date:
Subject: Re: [PERFORM] In progress INSERT wrecks plans on table