Migrating Postgres data using STDOUT/STDIN for two separate databases

Photo by Sigmund on Unsplash

Recently I worked on a project which used the CQRS pattern, which meant each of the services required a copy of data for other microservices, since there was no inter service communication.

To communicate between services, Kafka was used for producing and consuming messages.