I have PostgreSQL server installed in Windows. I'd like to send messages to RabbitMQ in functions and triggers. How can I do this? What additional tolls do I need?
I have PostgreSQL server installed in Windows. I'd like to send messages to RabbitMQ in functions and triggers. How can I do this? What additional tolls do I need?
You should use logical replication and write code or script for the append database change in RabbitMQ queue, also you can use pg-bifrost from github. This code use Logical Decoding (this feature use in postgres 9.6 and above) and RabbitMQ.