Postgres and Elasticsearch Realtime Sync

TL;DR; Yes, it works.

Proof: SearchReplica You can stream changes from Postgres, and injest the data in any external database, like regular postgres replica does. Using Postgres replication functionality to keep data consistent, and almost realtime.

This would be start of series of posts, regarding pitfalls, mistakes and details of logical decoding. ToC: TBD;

• What is WAL, Slot and Logical Decoding
• Replication flow

You work with Postgress as database. Stream WAL (with logical decoding) into Elasticsearch. And use Elastic for search.