pg-recorder [](https://circleci.com/gh/diogob/pg-recorder)

July 25, 2017 ยท View on GitHub

This will record all messages received from database notifications using user defined functions.

To start recording just connect to the same database where the PostgREST-WS backend is running:

$ pg-recorder postgres://localhost/target_db -c target_channel -f dispatcher_function

This will open a database session listening in the target channel and will send every payload received to a user defined function with the signature dispatcher_function(channel text, message_payload text)

One can use multiple instances of pg-recorder and identify the target_channel using the first parameter passed to the dispatcher_function. The second parameter is the text containing the message payload. In the case of PostgREST-WS this is actually a JSON (which can be automatically cast inside the function).

Development

To run the tests using stack:

$ stack test