View Source Oban.Notifiers.Postgres (Oban v2.15.4)
A Postgres Listen/Notify based Notifier.
Postgres notifier in your Oban configuration:
config :my_app, Oban, notifier: Oban.Notifiers.Postgres
The notifications system is built on PostgreSQL's
LISTEN/NOTIFY functionality. Notifications
are only delivered after a transaction completes and are de-duplicated before publishing.
Typically, applications run Ecto in sandbox mode while testing, but sandbox mode wraps each test
in a separate transaction that's rolled back after the test completes. That means the
transaction is never committed, which prevents delivering any notifications.
To test using notifications you must run Ecto without sandbox mode enabled, or use
Register current process to receive messages from some channels
Unregister current process from channels