The logical replication features in 9.4 look very promising as an alternative to the binary replication that requires an identical schema on both ends. There's no reason that the thing you're replicating to couldn't be something like RabbitMQ or Storm.
I've been playing with a JSON-based decoder plugin so Postgres could emit changes to non-SQL systems like this. See https://bitbucket.org/btubbs/decoder_json/src. It should be still considered experimental and only used by people unafraid of hacking on C at this point. More eyeballs would be welcome.
I strongly suspect many would like further details on your implementation. A user conference session well recorded perhaps?
the details are proprietary and quite specific to our workload and requirements.
You could build something similar with Skytools; it's what Skype actually created it for. They ran many "real time" datamarts/warehouses using it.
The big difference between it and Slony is that Skytools is modular, so it's designed to allow for this kind of flexibility. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com
