This web content introduces pg_flo, a cloud offering that simplifies moving and transforming data between PostgreSQL databases. It offers real-time streaming for data changes, parallelizable bulk copy for fast synchronization, and powerful transformations such as masking sensitive data and flexible routing between tables. Surprising transformation rules include masking email addresses and formatting phone numbers. Users can route data between differently named tables and columns or sync production data to staging while maintaining data privacy. pg_flo leverages PostgreSQL’s logical replication system and NATS as a message broker for flexibility and scalability. It offers detailed setup instructions and is actively developed on GitHub.
https://www.pgflo.io/