News for hackers. Stuff that matters.
Re:A list of PostgreSQL libraries, tools and resources by Cieplak on Monday February 15, 2016 @03:38PM (#11105766)
Thank you. I believe that bidirectional replication will solve the ETL problem, if it can be configured to stream from a replica in the source/oltp cluster (to minimize network IO on the source cluster master db) to the master of the destination/olap cluster. The olap master can mirror the oltp data, but also use triggers to denormalize oltp tables.

One thing I'd like to see is the ability to sanitize/munge data from the source cluster before it is sent to the destination cluster, for masking sensitive data in the source cluster (PCI, HIPAA, etc).

There are no comments on this comment yet.