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